In this episode of Scaling Postgres, we review articles covering modeling, checking for long queries using pg_stat_statements, statistics in PosgreSQL 10 and pgmetrics.
Head on over to https://www.scalingpostgres.com to get notified of new episodes.
Links for this episode:
- https://tapoueh.org/blog/2018/03/database-modelization-anti-patterns/
- https://www.cybertec-postgresql.com/en/detecting-performance-problems-easily-in-postgresql/
- https://www.citusdata.com/blog/2018/03/06/postgres-planner-and-its-usage-of-statistics/
- https://www.opsdash.com/blog/announcing-pgmetrics.html
- https://severalnines.com/blog/top-pg-clustering-ha-solutions-postgresql
- https://blog.2ndquadrant.com/postgresql-meltdown-benchmarks/
- https://www.scalingpostgres.com/tutorials/postgresql-backup-point-in-time-recovery/