How a single PostgreSQL config change improved slow query performance by 50x
Read how changing a single PostgreSQL config improved slow query performance by 50x in the Amplitude Engineering Blog.
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.
Pavan Patibandla
Director of Engineering, Amplitude
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 PavanRecommended Reading
Amplitude + GitHub Agents: Closing the Product Learning Loop
Oct 19, 2026
4 min read
Lessons from consolidating our MCP server
Oct 6, 2026
10 min read
What AI engineers do in the age of agentic code
Oct 1, 2026
14 min read
An analysis of Jev: Faster and cheaper, but watch the accuracy
Sep 28, 2026
13 min read
Explore Related Content
9 Top Feature Flag Solutions for Modern Product Teams in 2026
Jan 27, 2026
Using behavioral analytics for growth with the Amplitude app on HubSpot
Jun 17, 2024
10 min read
Identity resolution: The secret to a 360-degree customer view
Feb 16, 2024
10 min read
Inside warehouse-native Amplitude: A technical deep dive
Jun 27, 2023
15 min read
5 Proven Strategies to Boost Customer Engagement
Jul 12, 2023
Designing High-Impact Experiments
May 13, 2024
9 direct-to-consumer marketing tactics to accelerate ecommerce growth
Feb 20, 2024
10 min read
Leveraging analytics to achieve product-market fit
Jul 20, 2023
10 min read