r/SQL • • May 17 '18

PostgreSQL Simple tips for PostgreSQL query optimization

https://statsbot.co/blog/postgresql-query-optimization/
3 Upvotes

1 comment sorted by

1

u/timetravelhunter May 30 '18

"Indexes are materialized copies of your table" -- what? That's not true. It's almost like their idea of an index is a columnar storage version of selected fields.