Postgresql performance tuning - a crash course
Presented by:
Malcolm McLean
Malcolm is a Software Engineer, PostgreSQL DBA, Linux admin, tinkerer and a bit of a pedantic perfectionist, having over 19 years of experience with PostgreSQL and somewhat more than that with Linux and development.
No video of the event yet, sorry!
Out of the box PostgreSQL comes with very conservative performance settings. In this 3-hour workshop, we'll look at more useful 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.
- Date:
- 2019 September 18 09:00 PDT
- Duration:
- 3 h
- Room:
- Winchester (1)
- Conference:
- Silicon Valley 2019
- Language:
- Track:
- Ops and Administration
- Difficulty:
- Medium
- Requires Registration:
- Yes (Registered: 28/27)