Search

Home > Scaling Postgres > Episode 112 Explain Analyze | Sequence Counts | Best Books | Partition Migration


	Podcast:		Scaling Postgres
	Episode:		Episode 112 Explain Analyze \| Sequence Counts \| Best Books \| Partition Migration
	Category:		Technology
	Duration:		00:16:45
	Publish Date:		2020-05-04 02:51:33
	Description:		In this episode of Scaling Postgres, we discuss how to use explain analyze, the problem with counting sequences, the best books to learn Postgres and how to migrate to declarative partitioning. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.highgo.ca/2020/04/30/optimizing-sql-step-1-explain-costs-and-plans-in-postgresql-part-2/ https://www.enterprisedb.com/postgresql-query-optimization-performance-tuning-with-explain-analyze https://www.cybertec-postgresql.com/en/speeding-up-count-why-not-use-maxid-minid/ https://www.youtube.com/watch?v=KTRB12-xeHY https://www.2ndquadrant.com/en/blog/how-to-migrate-from-inheritance-based-partitioning-to-declarative-partitioning-in-postgresql/ https://info.crunchydata.com/blog/using-postgresql-for-json-storage https://elephas.io/how-to-set-application_name-in-psql-command-line-utility/ https://www.2ndquadrant.com/en/blog/password-authentication-methods-in-postgresql/ https://www.2ndquadrant.com/en/blog/oracle-to-postgresql-ansi-outer-join-syntax-in-postgresql/ https://severalnines.com/database-blog/my-favorite-postgresql-extensions-part-one https://severalnines.com/database-blog/my-favorite-postgresql-extensions-part-two https://www.citusdata.com/blog/2020/04/27/how-citus-distributed-query-executor-adapts-to-postgres-workload/ https://postgresql.life/post/melanie_plageman/ https://info.crunchydata.com/blog/a-deep-dive-into-postgis-nearest-neighbor-search https://www.cybertec-postgresql.com/en/intersecting-tracks-of-individuals-mobilitydb/ https://www.2ndquadrant.com/en/blog/how-to-use-tree-machine-learning-model-with-2uda-postgresql-and-orange-part-4/
	Total Play:		0