---
title: A balanced approach to automatic Postgres indexing
---

Launching the new version of the pganalyze Index Advisor based on the pganalyze Indexing Engine, an automatic system for Postgres indexing.

| View in browser Hi there,   Welcome to a special announcement newsletter for our May 2022 issue of the pganalyze newsletter!   Today, we are very proud to announce the new and improved version of the pganalyze Index Advisor, based on the new pganalyze Indexing Engine! Learn more about why we are so excited about this below. Of course, you will also find a re-cap and links to our latest 5mins of Postgres episodes.   Interested to hear more in a webinar? Join us on June 16th, 9:30am PDT for "How to reason about indexing your Postgres database".   - - - pganalyze Index Advisor     The new version of the pganalyze Index Advisor provides you a database-wide overview of missing and unused index recommendations.    This represents a leap forward from our initial release of Index Advisor - now opportunities are assessed for the whole table, and indexes are optimized to cover multiple queries, whilst keeping Index Write Overhead low.   Read more in the announcement blog post: A balanced approach to automatic Postgres indexing with the new version of the pganalyze Index Advisor→   We'll also give a detailed walk-through and a behind-the-scenes of the methodology that lead us to build the Indexing Engine and the Index Advisor on June 16th, 9:30am PDT and would love to see you there: Webinar Registration: How to reason about indexing your Postgres database →   If you like what we have built, we'd appreciate if you could share the blog post and the webinar on twitter→   - - - pganalyze Indexing Engine   The foundation of the new features launched today is the new pganalyze Indexing Engine. We built the engine to be a system thats repeatable, transparent, and can be introspected.   It represents over a year of effort from our team, and we're excited to share it with you today.   Read more in our technical deep-dive blog post: An automatic indexing system for Postgres: How we built the pganalyze Indexing Engine→   If you want to share this article on twitter, you can do so here→   - - -   5mins of Postgres - episodes from May:   E17: Demystifying Postgres for application developers: A mental model for tables and indexes→ We walk through a mental model for how to think about databases as an application developer and explain Postgres Tables, Indexes, Index Cardinality & Table scans (share this episode here).   E18: Partition pruning, prepared statements and generic vs custom query plans→ In this episode, we talk about partition pruning and prepared statements in Postgres and run a performance test using the pgbench tool (share this episode here).   E19: Speeding up sort performance in Postgres 15→ Here, we look at four specific improvements made in Postgres 15 that help speeding up sort performance: Sorting a single column, specialized sort routines for common datatypes, and more (share this episode here).    Subscribe to the pganalyze YouTube channel to stay up to date about our weekly videos→   - - -   Product changes in April: The new pganalyze Indexing Engine, runs in the background and continuously monitors your database for missing indexes New version of the pganalyze Index Advisor, showing recommendations by the Indexing Engine New Index Write Overhead metric, to help you assess the impact of adding new indexes, or removing unused indexes New Scans information on both table and query pages - scans describe the WHERE/JOIN conditions in the query, separated by table (read more in the docs) The "Index check" has been merged into the per-query Index Advisor information (this does not apply to legacy plans) Enterprise release 2022.05.1 This is a bugfix release on top of the 2022.05.0 release - we recommend upgrading Multiple security fixes Bugfixes Table/index treemap: Fix bug that showed incorrect names when the same name was used in different schcemas Fix bug that didn't allow realtime check-ups to be deactivated - - -    As always, I'm happy to hear from you and am personally reading all of your responses. Looking forward to your thoughts!   Have a nice day! Lukas & the pganalyze team   PS: If you're interested in giving pganalyze a try you can learn more about it here. Of course, I'd be happy to walk you through a demo on a video call. You can book a 30 minute meeting with me here. Or, if you have general requests, feel free to get in touch with us here. Duboce Labs, Inc., 1501 Mariposa St, Unit 408, San Francisco, CA 94107 Unsubscribe Manage preferences |
| --- |