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.

December 1, 2017
Senior Software Engineer
How 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
Senior Software Engineer
Pavan is Senior BackEnd Engineer 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 Perspectives
January 8, 2025
Experience Design Leader
January 6, 2025
Group Product Marketing Manager, Amplitude
December 9, 2024
Startup Programs Manager
November 12, 2024
CEO & Co-founder
Platform
Resources
Support
Partners
Company
© 2025 Amplitude, Inc. All rights reserved. Amplitude is a registered trademark of Amplitude, Inc.