Tuning PostgreSQL for High Write Workloads
Grant McAlister is a Senior Principal Engineer at Amazon Web Services where he works on RDS - Amazon's Relational Database Service, the service he helped found 10 years ago. Prior to AWS, Grant was responsible for the performance, scalability and availability of Amazon's databases. Before joining Amazon.com in 1999, Grant worked as an Independent Database Consultant and as a Senior Principle Consultant for Oracle Corporation. He earned a B.S. in Computer Science at the University of Alberta.
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.
- 50 min
- PostgresConf US 2018
- Postgres Internals