Performance tuning PostgreSQL
Malcolm is a PostgreSQL DBA, Linux admin, Java/PHP developer, tinkerer and a bit of a pedantic perfectionist, having over 13 years of experience with PostgreSQL and somewhat more than that with Linux and development.
He is also an organiser of PostgresConf South Africa.
No video of the event yet, sorry!
Presented as full-day training
Out of the box PostgreSQL comes with very conservative performance settings. In this workshop, we'll look at many of the options that relate to performance and how to set them for your environment, as well as query optimization, statistics, operating system parameters and server resources.
There is no one-size-fits-all approach, but through this workshop, you'll get the fundamentals of performance tuning PostgreSQL and how to best apply it to your configuration and workload.
- 2019 March 18 09:00 EDT
- 7 h
- Postgres Conference
- Ops and Administration