How a single PostgreSQL config change improved slow query performance by 50x
Pavan Patibandla
3.1K12

Nice. The parameter that had the biggest impact for us is incrementing work_mem (by a lot). We’ve also considered tuning random_page_cost, but haven’t seen a query that would benefit from it in our workload yet. But maybe we should do it anyway instead of waiting for a fire to happen :)

Like what you read? Give Felix Geisendörfer a round of applause.

From a quick cheer to a standing ovation, clap to show how much you enjoyed this story.