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.

Subscribe at https://www.scalingpostgres.com to get notified of new episodes.

Links for this episode:

https://www.youtube.com/watch?v=aVty0_qcPzM

https://info.crunchydata.com/blog/deep-postgresql-thoughts-resistance-to-containers-is-futile

https://www.cybertec-postgresql.com/en/postgresql-analyze-and-optimizer-statistics/

https://www.cybertec-postgresql.com/en/postgresql-create-statistics-advanced-query-optimization/

https://aaronbos.dev/posts/query-postgresql-json

https://info.crunchydata.com/blog/tentative-smarter-query-optimization-in-postgres-starts-with-pg_stat_statements

https://blog.rustprooflabs.com/2021/02/postgres-postgis-why-partition-openstreetmap

https://blog.rustprooflabs.com/2021/02/postgres-postgis-partition-openstreetmap-road

https://info.crunchydata.com/blog/arcgis-feature-service-to-postgis-the-qgis-way

https://postgresql.life/post/valeria_kaplan/