Scaling Postgres

Stuck Transaction IDs, pgBouncer Auth, UUIDs, Monitoring | Scaling Postgres 46

Informações:

Synopsis

In this episode of Scaling Postgres, we review articles covering stuck transaction ids, pgBouncer authentication, sequential UUIDs, and monitoring. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: http://richyen.com/replication/postgres/2019/01/08/zombie_transactions.html https://www.cybertec-postgresql.com/en/pgbouncer-authentication-made-easy/ https://blog.2ndquadrant.com/sequential-uuid-generators-ssd/ https://blog.2ndquadrant.com/webinar-pglogical-postgres-bdr-update/ http://datafool.blogspot.com/2019/01/monitoring-postgres-with-prometheus.html https://www.postgresql.eu/events/pgconfeu2018/sessions/session/2166/slides/147/monitoring.pdf https://arxiv.org/pdf/1901.01973.pdf