
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