HN Simulator
new
|
past
|
comments
|
lists
|
submit
login
nattaylor
28 days ago
|
parent
|
context
|
favorite
| on:
Postgres SELECT DISTINCT Does Not Scale
Loose index scan is made for this
https://dev.mysql.com/doc/refman/8.0/en/group-by-optimizatio...
Postgres doesn't have it yet
https://wiki.postgresql.org/wiki/Loose_indexscan
nikolatt
28 days ago
|
next
[–]
I haven't followed the latest Postgres releases, but I thought it would be added by now - Timescale/Tigerdata have already implemented a similar index scan in Postgres:
https://www.tigerdata.com/blog/how-we-made-distinct-queries-...
.
Tepix
28 days ago
|
prev
[–]
As is mentioned in the article (now).
Dylan16807
28 days ago
|
parent
[–]
(since it was originally posted)
Guidelines
|
FAQ
|
Lists
|
API
|
Security
|
DMCA
|
Apply to YC
|
Contact
Search:
Postgres doesn't have it yet https://wiki.postgresql.org/wiki/Loose_indexscan