Episode 195 Aurora vs. Postgres | Surprising Transactions | Write-Only & Read-Only | Indexing Advice

<p>In this episode of Scaling Postgres, we discuss Aurora vs. Postgres, surprising transaction behavior, write-only & read-only database connections and indexing best practices.</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.migops.com/blog/2021/11/26/is-aurora-postgresql-really-faster-and-cheaper-than-rds-postgresql-benchmarking/"> https://www.migops.com/blog/2021/11/26/is-aurora-postgresql-really-faster-and-cheaper-than-rds-postgresql-benchmarking/</a><br /> <br /> <a href= "https://blog.lawrencejones.dev/isolation-levels/">https://blog.lawrencejones.dev/isolation-levels/</a><br /> <br /> <a href= "https://www.enterprisedb.com/blog/taking-advantage-write-only-and-read-only-connections-pgbouncer-django"> https://www.enterprisedb.com/blog/taking-advantage-write-only-and-read-only-connections-pgbouncer-django</a><br /> <br /> <a href= "https://www.pgmustard.com/blog/indexing-best-practices-postgresql"> https://www.pgmustard.com/blog/indexing-best-practices-postgresql</a><br /> <br /> <a href= "http://aklaver.org/wordpress/2021/12/07/postgres-and-json/">http://aklaver.org/wordpress/2021/12/07/postgres-and-json/</a><br /> <br /> <a href= "http://rhaas.blogspot.com/2021/12/surviving-without-superuser-part-one.html"> http://rhaas.blogspot.com/2021/12/surviving-without-superuser-part-one.html</a><br /> <br /> <a href= "https://blog.crunchydata.com/blog/extracting-and-substituting-text-with-regular-expressions-in-postgresql"> https://blog.crunchydata.com/blog/extracting-and-substituting-text-with-regular-expressions-in-postgresql</a><br /> <br /> <a href= "https://fluca1978.github.io/2021/12/06/pgterminatebackend.html">https://fluca1978.github.io/2021/12/06/pgterminatebackend.html</a><br /> <br /> <a href= "https://www.highgo.ca/2021/12/10/a-look-inside-postgresqls-extended-query-protocol/"> https://www.highgo.ca/2021/12/10/a-look-inside-postgresqls-extended-query-protocol/</a><br /> <br /> <a href= "https://www.cy