Scaling Postgres

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. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.enterprisedb.com/blog/pg-phriday-tidying-vacuum https://www.cybertec-postgresql.com/en/drop-role-or-drop-user-postgresql/ https://www.depesz.com/2022/03/31/waiting-for-postgresql-15-add-support-for-merge-sql-command/ https://www.postgresql.org/docs/devel/sql-merge.html https://www.youtube.com/watch?v=ddKm7a7xOpk https://www.depesz.com/2022/03/31/waiting-for-postgresql-15-sql-json-constructors/ 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-sql-json-query-functions/ https://www.highgo.ca/2022/03/31/parallel-commit-in-postgres-fdw/ https://pganalyze.com/blog/how-postgres-chooses-index https://postgrespro.com/blog/pgsql/5969403 https://www.citusdata.com/blog