Episode 112 Explain Analyze | Sequence Counts | Best Books | Partition Migration

<p>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.</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.highgo.ca/2020/04/30/optimizing-sql-step-1-explain-costs-and-plans-in-postgresql-part-2/"> https://www.highgo.ca/2020/04/30/optimizing-sql-step-1-explain-costs-and-plans-in-postgresql-part-2/</a></p> <p><a href= "https://www.enterprisedb.com/postgresql-query-optimization-performance-tuning-with-explain-analyze"> https://www.enterprisedb.com/postgresql-query-optimization-performance-tuning-with-explain-analyze</a></p> <p><a href= "https://www.cybertec-postgresql.com/en/speeding-up-count-why-not-use-maxid-minid/"> https://www.cybertec-postgresql.com/en/speeding-up-count-why-not-use-maxid-minid/</a></p> <p><a href= "https://www.youtube.com/watch?v=KTRB12-xeHY">https://www.youtube.com/watch?v=KTRB12-xeHY</a></p> <p><a href= "https://www.2ndquadrant.com/en/blog/how-to-migrate-from-inheritance-based-partitioning-to-declarative-partitioning-in-postgresql/"> https://www.2ndquadrant.com/en/blog/how-to-migrate-from-inheritance-based-partitioning-to-declarative-partitioning-in-postgresql/</a></p> <p><a href= "https://info.crunchydata.com/blog/using-postgresql-for-json-storage"> https://info.crunchydata.com/blog/using-postgresql-for-json-storage</a></p> <p><a href= "https://elephas.io/how-to-set-application_name-in-psql-command-line-utility/"> https://elephas.io/how-to-set-application_name-in-psql-command-line-utility/</a></p> <p><a href= "https://www.2ndquadrant.com/en/blog/password-authentication-methods-in-postgresql/"> https://www.2ndquadrant.com/en/blog/password-authentication-methods-in-postgresql/</a></p> <p><a href= "https://www.2ndquadrant.com/en/blog/oracle-to-postgresql-ansi-outer-join-syntax-in-postgresql/"> https://www.2ndquadrant.com/en/blog/oracle-to-postgresql-ansi-outer-jo