Scaling Postgres

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/