Bruce Momjian, PostgreSQL Project
Track: Databases
Date: Monday, July 22
Time: 8:45am - 12:15pm
Location: Harbor Island I
Wondering about PostgreSQL hardware and query design optimization and performance tuning? Search no more! This session shows how to achieve good performance using caching and buffers in PostgreSQL, how to optimally size various parameter relating to memory usage, and recommends various disk layout optimizations to improve performance.
On the query side, we'll detail how PostgreSQL evaluates queries to see what is happening inside, and explore when to use various database features that enhance performance.
It also covers the various server parameters and their meanings.
