How a single PostgreSQL config change improved slow query performance by 50x

Pavan Patibandla

Senior Software Engineer

people reacted
< 1-minute Read,

Posted on December 1, 2017

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

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 from Pavan

#1 Product Intelligence

See how Amplitude helps you use customer data to build great product experiences that convert and retain users.

Explore Amplitude

Inside Amplitude