1 min readNov 24, 2017
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 :)