
Scaling Postgres Episode 63 | Slow Queries | pg_auto_failover | Roles | Hyperscale
Get New Episodes Weekly!
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.
Content Discussed
- How to identify slow queries in PostgreSQL
- Introducing pg_auto_failover: Open source extension for automated failover and high-availability in PostgreSQL
- PostgreSQL: Using CREATE USER with caution
- The role of a role within another role
- Introducing Hyperscale (Citus) on Azure Database for PostgreSQL
- [YouTube] Building PostgreSQL apps at any scale with Hyperscale (Citus) - BRK3094
- [YouTube] Unleash analytics on operational data with Hyperscale (Citus) on Azure Database for PostgreSQL
- PostgreSQL v12 new feature: optimizer support for functions
- pgBackRest – A Great Backup Solution and a Wonderful Year of Growth