Check out our free resources and eBooks like: "Effective Indexing in Postgres"

How to tune Postgres autovacuum to improve performance and reduce bloat

Tune your autovacuum settings to ensure that VACUUM runs at the right time and is effective for your workload.

Here is what you will learn in this webinar:

  • The physicality of tables
  • The Transaction ID clock
  • All-visible pages and slow queries
  • Understanding autovacuum scheduling
  • Cost delay 101
  • Aggressive and Failsafe VACUUMs
  • Dead tuples not yet removable
  • VACUUMing in the cloud - RDS, Aurora, Cloud SQL & AlloyDB
  • Estimating and fixing table bloat

How To Reason About Indexing Your Postgres Database

See how Postgres chooses which index to use, and learn a methodology for analyzing queries and optimizing indexes.

Here is what you will learn in this webinar:

  • How Postgres chooses which index to use
  • Background about indexing
  • What is a “good enough” index?
  • A structured approach for finding the right indexes
  • A look behind the scenes: The pganalyze Indexing Engine

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.

Here is what you will learn in this webinar:

  • 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
  • Finding the root cause of high I/O costs of cloud databases such as Amazon Aurora
  • and much more


Hundreds Of Companies Monitor Their Production PostgreSQL Databases With pganalyze

Atlassian
DoorDash
Moody's
fuboTv
Salsify
CounterPath
Ipsy

Robin Fernandes
pganalyze is essential to making our Postgres databases run faster, and makes sure end-users have the best experience possible.
- Robin Fernandes, Software Development Manager, Atlassian