How to reason about Indexing your Postgres database - Webinar Cover Image

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
Lukas Fittl
Founder & CEO, pganalyze

Learn about

  • 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

Watch the Webinar Recording

Hundreds Of Companies Monitor Their Production PostgreSQL Databases With pganalyze