Hi there,

Welcome to the February 2025 edition of the pganalyze newsletter! This month, we’re diving into key strategies to help you keep PostgreSQL running smoothly at scale, plus some updates from the Postgres community.

First, don’t miss our upcoming webinar on Proactive Postgres Practices to Prevent Performance Bottlenecks. We’ll cover essential monitoring techniques using pg_stat_io, pg_stat_statements, and other built-in tools, along with strategies for managing index bloat, tuning autovacuum, and optimizing connection limits before they become a problem.

I'm also hosting new Query Tuning office hours every Friday for the next few weeks, to work with current pganalyze customers to debug your slow Postgres queries. Limited timeslots are available, so get yours today!

Recently we've also published a case study on Notion's approach to scaling PostgreSQL. As their user base grew, slow queries and performance bottlenecks on Amazon RDS became more challenging to manage. Learn how they tackled it with pganalyze.

And on that note, we just released the new pganalyze Enterprise Server v2025.03.0 release, which includes the Query Tuning Workbooks beta and other improvements.

Want to meet our team in person? Find all upcoming events later in the newsletter. And as always, you’ll find all product updates at the end.

And a quick last note: We've recently refreshed our Terms of Service to align with industry standards and to allow them to be used for purchasing pganalyze Enterprise Server more easily.

All the best,

Lukas

Upcoming Webinar: Proactive Postgres Practices to Prevent Performance Bottlenecks

pganalyze_zoom image Proactive Postgres Practices to Prevent Performance Bottlenecks

As your PostgreSQL database grows, slow queries, bloat, and connection limits can quietly build up, leading to unexpected performance issues.

In this webinar, we’ll walk through key strategies for staying ahead of these challenges, from using pg_stat_io and pg_stat_statements to detect early warning signs to managing bloat with tools like REINDEX and pg_repack.

We’ll also discuss how tuning checkpoint settings can improve Write-Ahead Logging (WAL) performance and why analyzing Postgres logs is essential for catching slow queries and deadlocks before they become major issues. Join us to learn practical, proactive techniques to keep your database efficient and reliable.

Register now

How Notion Runs PostgreSQL at Scale on Amazon RDS with pganalyze

Rapid growth can expose hidden bottlenecks in your database infrastructure. For Notion, the explosive surge in users led to performance issues on their Postgres database on Amazon RDS. Facing slow queries and complex scaling challenges, they turned to pganalyze for deeper insights.

The result? Improved query performance, streamlined indexing, and a significant reduction in reliance on infrastructure specialists. By providing engineers with the right tools, Notion accelerates incident resolution and proactively tunes Postgres, catching issues before they impact production. Read the full story from our chat with Arka Ganguli & Ben Hughes.

Read now

Upcoming PostgreSQL community events

The Postgres community is kicking off 2025 with some great events, and we’re excited to be taking part.

In addition to PGConf.dev and the virtual POSETTE conference, PGDay Chicago has released its full schedule. If you’re attending, be sure to check out Keiko's talk on practical query tuning.

Stuck on a Slow Query? Sign Up for Office Hours

Struggling with a slow or complex Postgres query? Sign up for a 1-hour office hour session with Lukas and get hands-on query tuning help. Whether you’re troubleshooting performance bottlenecks, optimizing indexing strategies, or trying to understand execution plans, this is a great opportunity to get expert insights tailored to your workload.

Book time now