Case Study: Notion scales PostgreSQL performance and reliability with pganalyze

Notion speeds query performance by 8x with pganalyze

Notion, a popular productivity tool, faced significant challenges scaling its single Amazon RDS PostgreSQL database to handle exponential user growth. This led to outages, vacuum inefficiencies, and a lack of visibility into database internals. To address these issues, Notion adopted pganalyze to gain the deep performance insights needed to manage its database infrastructure effectively.

Using pganalyze, Notion's engineers gained visibility to pinpoint performance issues, optimize queries, and refine indexes. A key result was a 733% performance improvement on a specific query after a GIN index optimization, reducing runtime from 5000ms to 600ms. pganalyze became a critical first line of defense, enabling teams across the organization to independently resolve database issues and maintain reliability during rapid growth.

Notion