# 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 ](/blog/author/pavan-patibandla)

<!-- -->

[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.

Topics