Tuning PostgreSQL for High Write Workloads
Presented by:
David Wein
David is a Sr Principal Technologist at AWS where he works on Amazon Aurora. He currently heads the development of Aurora Limitless Database and has been a leader in the Aurora team since the inception of Aurora PostgreSQL. David has over 25 years of experience developing database kernels, having led development efforts in SAP HANA, SAP Sybase IQ, and SAP Sybase ASE. He is currently based in Seattle, USA.
No video of the event yet, sorry!
In this session we will cover a number of the way that you can tune PostgreSQL to better handle high write workloads. We will cover both application and database tuning methods as each type can have substantial benefits but can also interact in unexpected ways when you are operating at scale. On the application side we will look at write batching, use of GUID's, general index structure, the cost of additional indexes and impact of working set size. For the database we will see how wal compression, auto vacuum and checkpoint settings as well as a number of other configuration parameters can greatly affect the write performance of your database and application.
- Date:
- 2017 November 14 16:40 UTC
- Duration:
- 50 min
- Room:
- Issaquah
- Conference:
- PGConf Local: Seattle [PgConf.US]
- Language:
- Track:
- ops
- Difficulty:
- Medium