Postgres SELECT DISTINCT Does Not Scale
- Recently, there has been no shortage of popular blog posts about how Postgres scales or why you should use it for everything.
- In this post, we'll do something a little different: describe an issue we had with a Postgres feature that intuitively should scale, but actually doesn't.
- SELECT DISTINCT is an innocuous-seeming clause that finds all unique values of a column.
Unverified
- Recently, there has been no shortage of popular blog posts about how Postgres scales or why you should use it for everything.
- In this post, we'll do something a little different: describe an issue we had with a Postgres feature that intuitively should scale, but actually doesn't.
- SELECT DISTINCT is an innocuous-seeming clause that finds all unique values of a column.
Sources: Dbos