Episode 107 Showing Plans | Atomic | Configuration | Migrations

<p>In this episode of Scaling Postgres, we discuss how to show live query plans, the importance of atomic operations for scaling out, configuration options and DBaaS migrations.</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.cybertec-postgresql.com/en/pg_show_plans-watching-execution-plans-in-postgresql-live/"> https://www.cybertec-postgresql.com/en/pg_show_plans-watching-execution-plans-in-postgresql-live/</a></p> <p><a href= "https://www.highgo.ca/2020/03/26/optimizing-sql-step-1-explain-in-postgresql-part-1/"> https://www.highgo.ca/2020/03/26/optimizing-sql-step-1-explain-in-postgresql-part-1/</a></p> <p><a href= "https://www.highgo.ca/2020/03/24/atomic-commit-and-atomic-visibility-for-postgresql-explained/"> https://www.highgo.ca/2020/03/24/atomic-commit-and-atomic-visibility-for-postgresql-explained/</a></p> <p><a href= "https://mydbanotebook.org/post/troubleshooting-02/">https://mydbanotebook.org/post/troubleshooting-02/</a></p> <p><a href= "https://www.youtube.com/watch?v=13d4BDYSYyM">https://www.youtube.com/watch?v=13d4BDYSYyM</a></p> <p><a href= "https://www.percona.com/blog/2020/03/25/migrating-a-postgresql-database-between-dbaas-providers/"> https://www.percona.com/blog/2020/03/25/migrating-a-postgresql-database-between-dbaas-providers/</a></p> <p><a href= "https://www.cybertec-postgresql.com/en/embedded-sql-in-c-for-postgresql-with-ecpg-blog/"> https://www.cybertec-postgresql.com/en/embedded-sql-in-c-for-postgresql-with-ecpg-blog/</a></p> <p><a href= "https://www.highgo.ca/2020/03/24/logical-replication-between-postgresql-and-mongodb/"> https://www.highgo.ca/2020/03/24/logical-replication-between-postgresql-and-mongodb/</a></p> <p><a href= "https://www.2ndquadrant.com/en/blog/developing-postgresql-windows-part-3/"> https://www.2ndquadrant.com/en/blog/developing-postgresql-windows-part-3/</a></p> <p><a href= "https://www.highgo.ca/2020/03/26/postgresql-gssapi-authentication-with-kerberos-part-2-postgresql-