Grant McAlister (Amazon Web Services) delivers the talk, "Tuning PostgreSQL for High-Write Workloads", on DAY 1 of the Percona Live Open Source Database Conference 2018, 4/24, at Santa Clara, CA.
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.
PostgreSQL High-Performance Tuning and Optimization
Why PostgreSQL Is Becoming A Migration Target For Enterprise
SQL Row Store vs Data Warehouse: Which Is Right for Your Application? - Robert Hodges - PLO October 2020
Introducing Kunlun Distributed Database Cluster - David Zhao Wei - Percona Live ONLINE 2020
pg_stat_monitor: A cool extension for better monitoring using PMM - Percona Live Online 2020
PostgreSQL WAL and Commit Synchronization, Optimization Opportunities - Jobin Augustine - PLO October 2020