Conference Schedule - PGConf.DE 2020

Back

PGIO, pg_hint_plan, pgSentinel to troubleshoot PostgreSQL application performance

Date: 2020-05-15
Time: 14:40–15:25
Room: Room 2

Coming to PostgreSQL after years of Oracle performance tuning, I realize that I approach PostgreSQL with tools and methods that are different from what a 'native' postgres DBA will start with. What made my job easier on Oracle is also available, and free, for PostgreSQL:

  • PGIO can be more appropriate than pgbench when analyzing the raw platform performance
  • pgSentinel, with its ASH sampling approach, is more focused at the root cause than statistics and ratios
  • pg_hint_plan has its use when trying to understand the query planner decisions

All those tools with why/how/when explanations and live demo.

Speaker

Franck Pachot