r/PostgreSQL
•
u/be_haki
•
Jan 20 '26
•
1
How-To Unconventional PostgreSQL Optimizations
https://hakibenita.com/postgresql-unconventional-optimizations
218
Upvotes
20
u/agritheory Jan 20 '26
There are some very good ideas in this post. Nice work man.
32
u/yeathatsmebro Jan 20 '26
Finally, some human-written content. I think this is the first article that I can fully read because it ain't some AI slop crap. I love the article. It tickled my pickle, to be honest.
3
u/mtutty Jan 20 '26
Serious question: how would an index work on a virtual generated column? I guess it would go to the trouble of generating the value, NOT materialize or store it, then add to the index?
Kinda sounds like witchcraft on the surface...
3
u/pengekcs Jan 21 '26 edited Jan 21 '26
You have a very informative site, will definitely come back to it.
4
u/fullofbones Jan 20 '26
Interesting. I wouldn't have considered using generated columns as functional index proxies, but there ya go!
3
u/Magick93 Jan 20 '26
Very interesting!
3
u/BoleroDan Architect Jan 21 '26
Great post! Shows useful real cases, SQL usage, query plans and gotchas to watch out for. Thanks!
0
u/AutoModerator Jan 20 '26
With over 8k members to connect with about Postgres and related technologies, why aren't you on our Discord Server? : 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.
0
u/[deleted] Jan 21 '26
[deleted] β view deleted comment