Scaling Postgres Episode 153 Int to BigInt | Resistance is Futile | Optimizer Statistics | Advanced Query Optimization

In this episode of Scaling Postgres, we discuss how to convert an integer primary key to a bigint, how container resistance is futile, how the optimizer uses statistics and how to set manual statistics.

Content Discussed

• Changing your huge table's data types in production [FOSDEM 2021] PostgreSQL
• Deep PostgreSQL Thoughts: Resistance to Containers is Futile
• PostgreSQL: ANALYZE and optimizer statistics
• PostgreSQL: CREATE STATISTICS – advanced query optimization
• Querying JSON Data in PostgreSQL
• Query Optimization in Postgres with pg_stat_statements
• Why Partition OpenStreetMap data?
• Partition OpenStreetMap data in PostGIS
• ArcGIS Feature Service to PostGIS: The QGIS Way
• Valeria Kaplan

YouTube Video