Re:Working around a case where the Postgres planner is “not ...
by Inviz on Tuesday August 03, 2021 @03:39AM
(#28046626)
Timescaledb adds a custom scan for speeding up distinct on out of the box. Just install extension, no extra work is needed.
https://blog.timescale.com/blog/how-we-made-distinct-queries...
I tried it and it really is that fast.
Re:Working around a case where the Postgres planner is “not ...
by andreareina on Tuesday August 03, 2021 @03:59AM
(#28046731)
Fork adding it to postgresql if anyone's interested: https://github.com/jesperpedersen/postgres/tree/indexskipsca...
This is cool, thanks! Bit of a limitation that it only works on a single DISTINCT ON column, hopefully they'll be able to extend it to more in the future. And hope it makes it in for everyone that's on stock postgresql!
Re:Working around a case where the Postgres planner is “not ...
by Inviz on Tuesday August 03, 2021 @08:56AM
(#28048576)
Yeah, indeed there's that limitation of a single distinct column. But it works for 80% cases, and it does not require any changes, so it's good. Looks like the earliest time proper implementation could hit mainline is 1.5years away.
Disclaimer: I've used both methods, but haven't tested the perf against each other or the self-join.