Episode 209 Tidy Vacuum, Dropping Roles, Merge Command, PgBouncer Tutorial

<p>In this episode of Scaling Postgres, we discuss how to optimize vacuum, how to drop roles, the new merge command in PG15 and a pgbouncer tutorial.</p> <p>Subscribe at https://www.scalingpostgres.com to get notified of new episodes.</p> <p>Links for this episode:</p> <ul> <li><a href= "https://www.enterprisedb.com/blog/pg-phriday-tidying-vacuum">https://www.enterprisedb.com/blog/pg-phriday-tidying-vacuum</a></li> <li><a href= "https://www.cybertec-postgresql.com/en/drop-role-or-drop-user-postgresql/"> https://www.cybertec-postgresql.com/en/drop-role-or-drop-user-postgresql/</a></li> <li><a href= "https://www.depesz.com/2022/03/31/waiting-for-postgresql-15-add-support-for-merge-sql-command/"> https://www.depesz.com/2022/03/31/waiting-for-postgresql-15-add-support-for-merge-sql-command/</a></li> <li><a href= "https://www.postgresql.org/docs/devel/sql-merge.html">https://www.postgresql.org/docs/devel/sql-merge.html</a></li> <li><a href= "https://www.youtube.com/watch?v=ddKm7a7xOpk">https://www.youtube.com/watch?v=ddKm7a7xOpk</a></li> <li><a href= "https://www.depesz.com/2022/03/31/waiting-for-postgresql-15-sql-json-constructors/"> https://www.depesz.com/2022/03/31/waiting-for-postgresql-15-sql-json-constructors/</a></li> <li><a href= "https://www.depesz.com/2022/04/01/waiting-for-postgresql-15-is-json-predicate/"> https://www.depesz.com/2022/04/01/waiting-for-postgresql-15-is-json-predicate/</a></li> <li><a href= "https://www.depesz.com/2022/04/01/waiting-for-postgresql-15-sql-json-query-functions/"> https://www.depesz.com/2022/04/01/waiting-for-postgresql-15-sql-json-query-functions/</a></li> <li><a href= "https://www.highgo.ca/2022/03/31/parallel-commit-in-postgres-fdw/"> https://www.highgo.ca/2022/03/31/parallel-commit-in-postgres-fdw/</a></li> <li><a href= "https://pganalyze.com/blog/how-postgres-chooses-index">https://pganalyze.com/blog/how-postgres-chooses-index</a></li> <li><a href= "https://postgrespro.com/blog/pgsql/5969403">https://postgrespro.com/blog/pgsql/5969403</a></li> <li><a href= "https://www.cit