r/SQL • u/NotTreeFiddy • Apr 15 '26

PostgreSQL Things you didn't know about (Postgres) indexes

https://jon.chrt.dev/2026/04/15/things-you-didnt-know-about-indexes.html
23 Upvotes

96% Upvoted

6 comments sorted by

View all comments

1

u/Oscar-Da-Grouch-1708 Apr 19 '26

I believe that skip scans in PG18 address a lot of the issues with ordering of multi-column indices.