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.
Grant McAlister is a Senior Principal Engineer at Amazon Web Services where he works on RDS - Amazon's Relational Database Service, the service he help found 9 years ago. For the past 18 years Grant has been 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. A 1991 graduate of the University of Alberta, Grant has been working with database systems for the past 25 years.