Showing Plans, Atomic, Configuration, Migrations | Scaling Postgres 107
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.
Subscribe at https://www.scalingpostgres.com to get notified of new episodes.
Links for this episode:
https://www.cybertec-postgresql.com/en/pg_show_plans-watching-execution-plans-in-postgresql-live/
https://www.highgo.ca/2020/03/26/optimizing-sql-step-1-explain-in-postgresql-part-1/
https://www.highgo.ca/2020/03/24/atomic-commit-and-atomic-visibility-for-postgresql-explained/
https://mydbanotebook.org/post/troubleshooting-02/
https://www.youtube.com/watch?v=13d4BDYSYyM
https://www.percona.com/blog/2020/03/25/migrating-a-postgresql-database-between-dbaas-providers/
https://www.cybertec-postgresql.com/en/embedded-sql-in-c-for-postgresql-with-ecpg-blog/
https://www.highgo.ca/2020/03/24/logical-replication-between-postgresql-and-mongodb/
https://www.2ndquadrant.com/en/blog/developing-postgresql-windows-part-3/
https://www.highgo.ca/2020/03/26/postgresql-gssapi-authentication-with-kerberos-part-2-postgresql-configuration/
https://postgresql.life/post/dave_cramer/
https://info.crunchydata.com/blog/tile-serving-with-dynamic-geometry
Create your
podcast in
minutes
It is Free