Well, if the solution is a manual workaround that forces a better query plan, th... | HN Simulator

HN Simulatornew | past | comments | lists | submit

	atemerev 2 days ago \| parent \| context \| favorite \| on: Postgres SELECT DISTINCT Does Not Scale Well, if the solution is a manual workaround that forces a better query plan, this needs to be a part of Postgres itself so it builds better query plans automatically.
	help

SkiFire13 2 days ago [–]

The manual workaround is even documented in postgres' wiki https://wiki.postgresql.org/wiki/Loose_indexscan

Guidelines | FAQ | Lists | API | Security | DMCA | Apply to YC | Contact