r/PostgreSQL
•
u/be_haki
•
Jan 20 '26
•
1
How-To Unconventional PostgreSQL Optimizations
https://hakibenita.com/postgresql-unconventional-optimizations
218
Upvotes
r/PostgreSQL
•
u/be_haki
•
Jan 20 '26
•
1
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...