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

16:45
 
Share
 

Manage episode 260720724 series 2140130
By Ruby Tree Software Inc and Creston Jamison. Discovered by Player FM and our community — copyright is owned by the publisher, not Player FM, and audio is streamed directly from their servers. Hit the Subscribe button to track updates in Player FM, or paste the feed URL into other podcast apps.

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/

164 episodes