Search


	Podcast:		Scaling Postgres
	Episode:		Episode 153 Int to BigInt \| Resistance is Futile \| Optimizer Statistics \| Advanced Query Optimization
	Category:		Technology
	Duration:		00:12:25
	Publish Date:		2021-02-21 22:56:34
	Description:		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/
	Total Play:		0