‹ BackHN Continuity

Thread

Postgres SELECT DISTINCT Does Not Scale

106 points · 28 comments · KraftyOne

  1. sandeepkd · · focus · HN ↗
    It says that the company is co-founded by Postgres creator. I find that bit hard to believe given that there is nothing novel in the article, probably discovery for them. I do understand that everyone has to go through their own journey to learn these things but at the same time when you are running business then seeking professional help isnt a bad idea.

    Based on my experience queries like these cannot scale, whatever you do. However if you are already on a path where you had invested a lot in such queries then hire a DBA, if you are not far off then hire an architect to model the data for better performance.

    1. stemchar · · focus · HN ↗
      It's Stonebraker, he has a history of doing this to sell shit to people who don't need it.
Open on Hacker News to reply ↗

Unofficial Hacker News client; not affiliated with Y Combinator.