Explain Analyze, Sequence Counts, Best Books, Partition Migration | Scaling Postgres 112
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/
Create your
podcast in
minutes
It is Free