|
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/ |