--- title: "How A Single PostgreSQL Config Change Improved Slow Query Performance By 50x | Amplitude" description: "Read how changing a single PostgreSQL config improved slow query performance by 50x in the Amplitude Engineering Blog." canonical: "https://amplitude.com/en-us/blog/how-a-single-postgresql-config-change-improved-slow-query-performance-by-50x" --- # How A Single PostgreSQL Config Change Improved Slow Query Performance By 50x | Amplitude Read how changing a single PostgreSQL config improved slow query performance by 50x in the Amplitude Engineering Blog. Source: https://amplitude.com/en-us/blog/how-a-single-postgresql-config-change-improved-slow-query-performance-by-50x --- [Pavan Patibandla](/blog/author/pavan-patibandla) [Director of Engineering, Amplitude](/blog/author/pavan-patibandla) [](https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Famplitude.com%2Fblog%2F%2Fblog%2Fhow-a-single-postgresql-config-change-improved-slow-query-performance-by-50x)[](https://www.linkedin.com/sharing/share-offsite/?url=https%3A%2F%2Famplitude.com%2Fblog%2F%2Fblog%2Fhow-a-single-postgresql-config-change-improved-slow-query-performance-by-50x)[](https://twitter.com/intent/tweet?url=https%3A%2F%2Famplitude.com%2Fblog%2F%2Fblog%2Fhow-a-single-postgresql-config-change-improved-slow-query-performance-by-50x\&text=How%20a%20single%20PostgreSQL%20config%20change%20improved%20slow%20query%20performance%20by%2050x)[](mailto:?subject=Checkout%20this%20Amplitude%20Article\&body=Check%20this%20out%3A%20https%3A%2F%2Famplitude.com%2Fblog%2F%2Fblog%2Fhow-a-single-postgresql-config-change-improved-slow-query-performance-by-50x) At Amplitude, our goal is to provide easy-to-use interactive product analytics, so everyone can find answers to their product questions. In order to provide a great user experience, Amplitude needs to provide these answers quickly. So when one of our customers complained about how long it took to load the event properties dropdown in the Amplitude UI, we started digging into it… ## Read about how we improved slow query performance by 50x on our Engineering Blog. About the author Pavan Patibandla Director of Engineering, Amplitude [More from Pavan](/blog/author/pavan-patibandla) Pavan is Director of Engineering at Amplitude, responsible for our Distributed query layer and ingestion pipeline. Pavan enjoys working on hard/unsolved problems and loves to learn new stuff. Prior to Amplitude Pavan worked on Distributed File Systems at Riverbed. [More from Pavan](/blog/author/pavan-patibandla) Topics #### Recommended Reading [Read ](/blog/amplitude-github-learning-loop) [Product](/blog/amplitude-github-learning-loop) ###### [Amplitude + GitHub Agents: Closing the Product Learning Loop](/blog/amplitude-github-learning-loop) [Oct 19, 2026](/blog/amplitude-github-learning-loop) [4 min read](/blog/amplitude-github-learning-loop) [Read ](/blog/lessons-from-consolidating-our-mcp-server) [Insights](/blog/lessons-from-consolidating-our-mcp-server) ###### [Lessons from consolidating our MCP server](/blog/lessons-from-consolidating-our-mcp-server) [Oct 6, 2026](/blog/lessons-from-consolidating-our-mcp-server) [10 min read](/blog/lessons-from-consolidating-our-mcp-server) [Read ](/blog/what-ai-engineers-do) [Insights](/blog/what-ai-engineers-do) ###### [What AI engineers do in the age of agentic code](/blog/what-ai-engineers-do) [Oct 1, 2026](/blog/what-ai-engineers-do) [14 min read](/blog/what-ai-engineers-do) [Read ](/blog/jev-analysis) [Insights](/blog/jev-analysis) ###### [An analysis of Jev: Faster and cheaper, but watch the accuracy](/blog/jev-analysis) [Sep 28, 2026](/blog/jev-analysis) [13 min read](/blog/jev-analysis) #### Explore Related Content [101](/compare/top-feature-flag-solutions-for-product-teams) ###### [9 Top Feature Flag Solutions for Modern Product Teams in 2026](/compare/top-feature-flag-solutions-for-product-teams) [Jan 27, 2026](/compare/top-feature-flag-solutions-for-product-teams) [Integration](/blog/amplitude-hubspot-behavioral-analytics) ###### [Using behavioral analytics for growth with the Amplitude app on HubSpot](/blog/amplitude-hubspot-behavioral-analytics) [Jun 17, 2024](/blog/amplitude-hubspot-behavioral-analytics) [10 min read](/blog/amplitude-hubspot-behavioral-analytics) [Personalization](/blog/identity-resolution-insights) ###### [Identity resolution: The secret to a 360-degree customer view](/blog/identity-resolution-insights) [Feb 16, 2024](/blog/identity-resolution-insights) [10 min read](/blog/identity-resolution-insights) [Product](/blog/warehouse-native-technical-deep-dive) ###### [Inside warehouse-native Amplitude: A technical deep dive](/blog/warehouse-native-technical-deep-dive) [Jun 27, 2023](/blog/warehouse-native-technical-deep-dive) [15 min read](/blog/warehouse-native-technical-deep-dive) [Guide](/resources/boost-customer-engagement) ###### [5 Proven Strategies to Boost Customer Engagement](/resources/boost-customer-engagement) [Jul 12, 2023](/resources/boost-customer-engagement) [Video](/designing-high-impact-experiments) ###### [Designing High-Impact Experiments](/designing-high-impact-experiments) [May 13, 2024](/designing-high-impact-experiments) [Startup](/blog/direct-to-consumer-marketing-tactics) ###### [9 direct-to-consumer marketing tactics to accelerate ecommerce growth](/blog/direct-to-consumer-marketing-tactics) [Feb 20, 2024](/blog/direct-to-consumer-marketing-tactics) [10 min read](/blog/direct-to-consumer-marketing-tactics) [Growth](/blog/analytics-product-market-fit) ###### [Leveraging analytics to achieve product-market fit](/blog/analytics-product-market-fit) [Jul 20, 2023](/blog/analytics-product-market-fit) [10 min read](/blog/analytics-product-market-fit)