Presentations given by group members at external events

PostgresLondon 2019 - An Oracle DBA approach to troubleshoot PostgreSQL application performance

by Franck Pachot

Europe/Zurich
London

London

Description

An Oracle DBA approach to troubleshoot PostgreSQL application performance

By Franck Pachot 

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 is more appropriate than pgbench when analyzing the platform performance - pgSentinel, with its ASH sampling approach, is more powerful than statistics and ratios - measuring work done, from Linux system calls, rather than response time, to ensure predictable and scalable performance Let's make them better known with some demos.