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/2022/03/29/ultimate-guide-to-citus-con-an-event-for-postgres/
- https://www.timescale.com/blog/identify-postgresql-performance-bottlenecks-with-pg_stat_statements/
- https://b-peng.blogspot.com/2022/03/pgo-v5-installation.html
- https://postgresql.life/post/claire_giordano/
- https://www.rubberduckdevshow.com/episodes/36-redundant-infrastructure-on-the-cheap/