Webinar: Optimizing Postgres I/O Performance and Costs

We dive into I/O optimization in Postgres and how tuning I/O helps reduce overall database costs.

Lukas Fittl
Founder & CEO, pganalyze

Common causes for I/O spikes in Postgres and how they affect infrastructure costs
How to map high read and/or write IOPS to database activity
Using EXPLAIN plans to find heavy hitting I/O intensive queries
Caching in Postgres, and how the buffer cache hit ratio can be improved to reduce I/O
Reducing write I/O from inefficient or unused indexes with high index write overhead
How inefficient data distribution affects index performance and causes high write IOPS
The checkpointing and background writer processes in Postgres
Tuning fsync overhead through tuning of synchronous_commit
Tuning memory configuration settings like work_mem to reduce temporary file I/O
Optimizing Linux Readahead and tuning effective_io_concurrency
Finding the root cause of high I/O costs of cloud databases such as Amazon Aurora
How pganalyze helps improve database performance and reduce I/O costs
Upcoming work in the Postgres community for asynchronous I/O, and why it matters