In this episode of Scaling Postgres, we discuss how Postgres is the world's best database, performance ramifications of subtransactions, the current state of sharding and safe schema changes.

Subscribe at https://www.scalingpostgres.com to get notified of new episodes.

Links for this episode:

https://www.2ndquadrant.com/en/blog/postgresql-is-the-worlds-best-database/

https://www.cybertec-postgresql.com/en/subtransactions-and-performance-in-postgresql/

https://www.highgo.ca/2020/03/12/horizontal-scalability-sharding-in-postgresql-core-missing-pieces-of-the-puzzle/

https://gocardless.com/blog/fear-free-postgresql-migrations-for-rails/

https://www.enterprisedb.com/blog/how-provision-and-deploy-highly-available-postgres-terraform-and-ansible-automation-scripts

https://momjian.us/main/writings/pgsql/cloud.pdf

https://www.2ndquadrant.com/en/blog/full-text-search-postgresql-webinar/

https://www.2ndquadrant.com/en/blog/with-a-little-help-from-my-friends/

https://www.2ndquadrant.com/en/blog/how-to-deploy-a-multi-master-bdr-cluster-in-kubernetes/

https://postgresql.life/post/christophe_pettus/

https://info.crunchydata.com/blog/crunchy-spatial-querying-spatial-features-with-pg_featureserv