In this episode of Scaling Postgres, we discuss Aurora vs. Postgres, surprising transaction behavior, write-only & read-only database connections and indexing best practices.

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

Links for this episode:

https://www.migops.com/blog/2021/11/26/is-aurora-postgresql-really-faster-and-cheaper-than-rds-postgresql-benchmarking/

https://blog.lawrencejones.dev/isolation-levels/

https://www.enterprisedb.com/blog/taking-advantage-write-only-and-read-only-connections-pgbouncer-django

https://www.pgmustard.com/blog/indexing-best-practices-postgresql

http://aklaver.org/wordpress/2021/12/07/postgres-and-json/

http://rhaas.blogspot.com/2021/12/surviving-without-superuser-part-one.html

https://blog.crunchydata.com/blog/extracting-and-substituting-text-with-regular-expressions-in-postgresql

https://fluca1978.github.io/2021/12/06/pgterminatebackend.html

https://www.highgo.ca/2021/12/10/a-look-inside-postgresqls-extended-query-protocol/

https://www.cybertec-postgresql.com/en/pg_rewrite-postgresql-table-partitioning/

https://supabase.com/blog/2021/12/03/pg-graphql

https://postgresql.life/post/emre_hasegeli/