Scaling Postgres

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-feat