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

<p>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.</p> <p>Subscribe at https://www.scalingpostgres.com to get notified of new episodes.</p> <p>Links for this episode:</p> <p><a href= "https://www.youtube.com/watch?v=aVty0_qcPzM">https://www.youtube.com/watch?v=aVty0_qcPzM</a><br /> <br /> <a href= "https://info.crunchydata.com/blog/deep-postgresql-thoughts-resistance-to-containers-is-futile"> https://info.crunchydata.com/blog/deep-postgresql-thoughts-resistance-to-containers-is-futile</a><br /> <br /> <a href= "https://www.cybertec-postgresql.com/en/postgresql-analyze-and-optimizer-statistics/"> https://www.cybertec-postgresql.com/en/postgresql-analyze-and-optimizer-statistics/</a><br /> <br /> <a href= "https://www.cybertec-postgresql.com/en/postgresql-create-statistics-advanced-query-optimization/"> https://www.cybertec-postgresql.com/en/postgresql-create-statistics-advanced-query-optimization/</a><br /> <br /> <a href= "https://aaronbos.dev/posts/query-postgresql-json">https://aaronbos.dev/posts/query-postgresql-json</a><br /> <br /> <a href= "https://info.crunchydata.com/blog/tentative-smarter-query-optimization-in-postgres-starts-with-pg_stat_statements"> https://info.crunchydata.com/blog/tentative-smarter-query-optimization-in-postgres-starts-with-pg_stat_statements</a><br /> <br /> <a href= "https://blog.rustprooflabs.com/2021/02/postgres-postgis-why-partition-openstreetmap"> https://blog.rustprooflabs.com/2021/02/postgres-postgis-why-partition-openstreetmap</a><br /> <br /> <a href= "https://blog.rustprooflabs.com/2021/02/postgres-postgis-partition-openstreetmap-road"> https://blog.rustprooflabs.com/2021/02/postgres-postgis-partition-openstreetmap-road</a><br /> <br /> <a href= "https://info.crunchydata.com/blog/arcgis-feature-service-to-postgis-the-qgis-way"> https://info.crunchydata.com/blog/arcgis-feature-service-to-postgis-the-qgis-way</a><b