5 ms·
Fork adding it to postgresql if anyone's interested: https://github.com/jesperpedersen/postgres/tree/indexskipscan https://github.com/jesperpedersen/postgres/tr
by andreareina 5y ago
Fork adding it to postgresql if anyone's interested: https://github.com/jesperpedersen/postgres/tree/indexskipscan 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!
- Inviz 5y agoYeah, 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.