Nachhaltiges Datenbank Performance Profiling in PostgreSQL
Sustainable Database Performance profiling in PostgreSQL
Thursday, June 25 at 10:20–11:10
-
Dirk Krautchick has been working as a solution architect at Aiven since November 2023. As a qualified computer scientist, he was the responsible database administrator and quality support engineer for a manufacturer of optimization software in the aviation sector for 9 years, where he built up his know-how in operating PostgreSQL or Oracle databases and application servers. In 2017 he decided to use his fascination for database technologies and his skills as a consultant in - among others - the financial and energy sector to continually deepen them. During this dynamic times, the enthusiasm and fascination for open source from the student time returned and became priority for him. Without losing the acquired Oracle database know-how PostgreSQL as a primary topic was expanded in terms of content, teams were recruited, customers were trained and targeted projects were carried out. In addition to many architectural consulting and performance tuning projects also migrations from Oracle to PostgreSQL are often the content of such projects. In order to implement the open source and PostgreSQL strategy even more aggressively, without losing focus on the technology a move technical sales in 2022 was inevitable - first as a sales engineer at EnterpriseDB and now as a solution architect at Aiven.
Die nachhaltige Sammlung von Performance-Daten von Datenbanksystemen für flexible und umfangreiche Auswertungen durch Snapshots und Reports sind bei kommerziellen Datenbank-Herstellern essentiell und bei DBAs ein beliebtes Feature.
Auch für PostgreSQL gibt es mit der Erweiterung PG_PROFILE eine geeignete Lösung dazu.
Dieser Vortrag beschreibt die Vorraussetzungen und das grundlegende Setup von PG_PROFILE und zeigt anhand von Beispielen und Praxis-Erfahrungen, wie man hiermit bei Performance Analysen vorgehen kann.
The sustainable collection of performance data from database systems for flexible and extensive evaluations through snapshots and reports are available from commercial database manufacturers and a essential and a popular feature for several DBAs. There is also a suitable solution for PostgreSQL with the extension PG_PROFILE. This talk describes the requirements and basic setup of PG_PROFILE and shows with examples and practical experiences how this can be used for proceeding performance analytics.
