Postgres SELECT DISTINCT Does Not Scale

Postgres SELECT DISTINCT performs surprisingly poorly. We explain why and how we mitigated it.