Episode 168 Managing Autovacuum | Better JSON | Avoiding Updates | OS Tuning

<p>In this episode of Scaling Postgres, we discuss managing autovacuum, better JSON in Postgres 14, how to avoid redundant updates and operating system tuning.</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.cybertec-postgresql.com/en/enabling-and-disabling-autovacuum-in-postgresql/"> https://www.cybertec-postgresql.com/en/enabling-and-disabling-autovacuum-in-postgresql/</a><br /> <br /> <a href= "https://blog.crunchydata.com/blog/better-json-in-postgres-with-postgresql-14"> https://blog.crunchydata.com/blog/better-json-in-postgres-with-postgresql-14</a><br /> <br /> <a href= "https://fluca1978.github.io/2021/06/03/PostgreSQLUpdateTrigger.html"> https://fluca1978.github.io/2021/06/03/PostgreSQLUpdateTrigger.html</a><br /> <br /> <a href= "https://www.enterprisedb.com/blog/tuning-debian-ubuntu-postgresql"> https://www.enterprisedb.com/blog/tuning-debian-ubuntu-postgresql</a><br /> <br /> <a href= "https://arctype.com/blog/postgres-performance-monitoring/">https://arctype.com/blog/postgres-performance-monitoring/</a><br /> <br /> <a href= "https://www.percona.com/blog/2021/06/02/postgres_fdw-enhancement-in-postgresql-14/"> https://www.percona.com/blog/2021/06/02/postgres_fdw-enhancement-in-postgresql-14/</a><br /> <br /> <a href= "https://paquier.xyz/postgresql-2/postgres-14-reindex-tbspace/">https://paquier.xyz/postgresql-2/postgres-14-reindex-tbspace/</a><br /> <br /> <a href= "https://pgsqlpgpool.blogspot.com/2021/05/dropping-support-for-version-2-protocol.html"> https://pgsqlpgpool.blogspot.com/2021/05/dropping-support-for-version-2-protocol.html</a><br /> <br /> <a href= "https://yugonagata-pgsql.blogspot.com/2021/05/implementing-incremental-view.html"> https://yugonagata-pgsql.blogspot.com/2021/05/implementing-incremental-view.html</a><br /> <br /> <a href= "https://www.highgo.ca/2021/05/31/getting-started-with-pg_bulkload/"> https://www.highgo.ca/2021/05/31/getting-started-with-pg_bulkload/</a><br /> <b