2024-08-04, 10:45–11:15 (Asia/Taipei), TR409-2
PoWA is a postgres-centric and extensible workload analyzer that gives a broad overview of what is happening on a postgres server and its various subsystems.
If you hit a performance problem on your database, PoWA can tell you why!
This talk will present the PoWA suite and its exclusive features like the global index advisor which optimizes your whole workload and not a single query.
It will also present various extensions and datasources that can be used with PoWA, what information they give and what can be learned from them and how they are displayed in PoWA:
Julien is a PostgreSQL Major Contributor. He has been working with PostgreSQL since verson 8.3, as a developer and a DBA. He has many contribution to PostgreSQL itself. He's also the author of other open source projects such as PoWA (real-time performance diagnosis) and HypoPG (hypothetical indexes).
He’s also a former treasurer of the PostgreSQL Europe association.