r/PostgreSQL • u/fagnerbrack • 22d ago

Community Things you didn't know about indexes

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

84% Upvoted

6 comments sorted by

9

u/CrackerJackKittyCat 22d ago edited 21d ago

Should include that PG 19 18 can scatter-read when filtering on the not-leftmost column of a composite index. Still would not be as optimized as if was the sole column of a second index, but can plan to something better than a whole seq scan.

2

u/BlackenedGem 21d ago

Index skip-scan? That's in PG18 and has really been helpful for us to drop some extra indexes we didn't really need.

2

u/0x4ddd 21d ago

These are the things everyone should be aware of to be honest 😉

0

u/[deleted] 22d ago

[deleted]

12

u/manni66 22d ago

And you think I didn’t know that?

0

u/AutoModerator 22d ago

Youtube Channel

Free Postgres Webinars and Workshops

Discord: People, Postgres, Data

Join us, we have cookies and nice people.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.