Slow Queries, pg_auto_failover, Roles, Hyperscale | Scaling Postgres 63
In this episode of Scaling Postgres, we review articles covering how to identify slow queries, the pg_auto_failover utility, working with roles and Hyperscale.
Subscribe at https://www.scalingpostgres.com to get notified of new episodes.
Links for this episode:
https://dev.to/pythonmeister/how-to-identify-slow-queries-in-postgresql-4igk
https://cloudblogs.microsoft.com/opensource/2019/05/06/introducing-pg_auto_failover-postgresql-open-source-extension-automated-failover-high-availability/
https://www.cybertec-postgresql.com/en/postgresql-using-create-user-with-caution/
https://fluca1978.github.io/2019/05/09/PostgreSQL_Roles.html
https://www.citusdata.com/blog/2019/05/06/introducing-hyperscale-citus-on-azure-database-for-postgres/
https://www.youtube.com/watch?v=hEbK05xmUcc
https://www.youtube.com/watch?v=-cbT64D9KFk
https://www.cybertec-postgresql.com/en/optimizer-support-functions/
https://www.percona.com/blog/2019/05/10/pgbackrest-a-great-backup-solution-and-a-wonderful-year-of-growth/
Create your
podcast in
minutes
It is Free