Top Five PostgreSQL Surprises from Rails Devs | Andrew Atkinson

At Sin City Ruby 2024 earlier this year, I presented a series of advanced PostgreSQL topics to Rails programmers. Afterwards, a number of people provided feedback on surprising or interesting things from the presentation.Let’s cover the top five items in no particular order.Covering indexes and how to use themPostgreSQL data storage in pages and the relationship to query performanceTopics related to storing and accessing ordered dataWhy SELECT * is not optimal, and how to enumerate all table columns in queries to help spot opportunities to reduce the columnsUsing PostgreSQL for more types of work.