Postgres Releases, Useless Vacuum, Isolation Differences, WAL Compression | Scaling Postgres 101
In this episode of Scaling Postgres, we discuss new postgres releases, useless vacuuming, isolation differences between databases, and different ways to compress WAL files.
Subscribe at https://www.scalingpostgres.com to get notified of new episodes.
Links for this episode:
https://www.postgresql.org/about/news/2011/
https://www.postgresql.org/developer/roadmap/
http://rhaas.blogspot.com/2020/02/useless-vacuuming.html
https://postgresql.verite.pro/blog/2020/02/14/isolation-repeatable-read-postgresql-mysql.html
https://www.percona.com/blog/2020/02/13/compression-of-postgresql-wal-archives-becoming-more-important/
https://www.pgmustard.com/blog/work-mem
https://medium.com/@apoor/quickly-load-csvs-into-postgresql-using-python-and-pandas-9101c274a92f
https://fluca1978.github.io/2020/02/09/PostgreSQLDROPCOlumn.html
https://www.cybertec-postgresql.com/en/migrating-from-ms-sql-to-postgresql-uppercase-vs-lowercase/
https://www.2ndquadrant.com/en/blog/how-to-automate-postgresql-12-replication-and-failover-with-repmgr-part-2/
https://blog.smallcase.com/repmgr-with-postgres11-failover-and-recovery/
https://www.2ndquadrant.com/en/blog/creating-a-postgresql-procedural-language-part-2-embedding-julia/
https://www.enterprisedb.com/blog/can-pgbouncer-survive-transient-network-events
https://vladmihalcea.com/postgresql-array-java-list/
Create your
podcast in
minutes
It is Free