In this episode of Scaling Postgres, we discuss managing autovacuum, better JSON in Postgres 14, how to avoid redundant updates and operating system tuning.

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

Links for this episode:

https://www.cybertec-postgresql.com/en/enabling-and-disabling-autovacuum-in-postgresql/

https://blog.crunchydata.com/blog/better-json-in-postgres-with-postgresql-14

https://fluca1978.github.io/2021/06/03/PostgreSQLUpdateTrigger.html

https://www.enterprisedb.com/blog/tuning-debian-ubuntu-postgresql

https://arctype.com/blog/postgres-performance-monitoring/

https://www.percona.com/blog/2021/06/02/postgres_fdw-enhancement-in-postgresql-14/

https://paquier.xyz/postgresql-2/postgres-14-reindex-tbspace/

https://pgsqlpgpool.blogspot.com/2021/05/dropping-support-for-version-2-protocol.html

https://yugonagata-pgsql.blogspot.com/2021/05/implementing-incremental-view.html

https://www.highgo.ca/2021/05/31/getting-started-with-pg_bulkload/

https://b-peng.blogspot.com/2021/05/postgres-disaster-recovery-on-k8s.html

http://blog.cleverelephant.ca/2021/05/postgis-20-years.html

https://lesovsky.medium.com/pgscv-metrics-exporter-for-postgresql-not-only-7345f7bdbaa0

https://postgresql.life/post/nikolay_samokhvalov/