PostgreSQL Performance Tuning
Tuesday, September 09 at 11:10–12:00
Auditorium
Intermediate
Current versions of Postgres have sensible default settings and behavior, that work well for small and medium sized data (until a few hundred GB) or transaction volume and require not a lot of fine-tuning.
Nevertheless, we have multiple times seen and analyzed performance issues our customers encountered. This talk will give an overview over some areas of performance tuning covering the following areas:
- Memory configuration parameter tuning
- Storage parameter and checkpoint tuning
- Autovacuum tuning
- Introduction to query tuning