Road to Percona Live 2022 - Hamid Akhtar
summary
Three short sessions list concrete takeaways: replication conflicts digs into PostgreSQL internals and shows how database_conflicts view increments and which settings actually reduce those counters; high availability defines measurable criteria and compares real open‑source candidates and their operational tradeoffs; query performance demonstrates using pg_stat_activity, pg_stat_statements, auto_explain, pgBadger and pg_stat_monitor to stitch application calls to execution plans and cites a case where a query is <1s in psql but 3.5 hours from the app.
AI-written summary · about
chapters (4)
- 0:00Intro
- 0:33PostgreSQL Replication Conflicts
- 2:14PostgreSQL High Availability
- 3:55Query Performance Insights
related talks
42mPostgreSQL Replication Conflicts: Avoiding Pitfalls
39mDeep dive into PostgreSQL internal statistics
51mPostgreSQL Replication Conflicts: Avoiding Pitfalls
11h 21mPercona Community Live Conference - Day 3 - Open Source Databases Conference
18mPower Hour, Managing Databases at Scale – Peter Zaitsev
51mExploring new enhancements and improvements Fujitsu has delivered to
14mBuilding a better PostgreSQL together
48mUnderstanding and Reducing Application Contention