Scaling Postgres Episode 153 Int to BigInt | Resistance is Futile | Optimizer Statistics | Advanced Query Optimization
Get New Episodes Weekly!
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
