Postgres Pro
Downloads
Home   >   mailing lists

Re: Increasing work_mem slows down query, why? - Mailing list pgsql-performance

From Pavel Stehule
Subject Re: Increasing work_mem slows down query, why?
Date
Msg-id CAFj8pRAS6jM9AfHu7R_Rg4VGOPbZRmS1VJxcWG+Y69u_cLXReQ@mail.gmail.com
Whole thread Raw
In response to Re: Increasing work_mem slows down query, why?  (Silvio Moioli <moio@suse.de>)
List pgsql-performance
Tree view


Is that an unreasonable value? For the sake of this discussison, I am targeting fairly average bare-metal SSD-backed servers with recent CPUs (let's say 3 year old maximum), with ample available RAM.

if you have SSD, then you can decrease RANDOM_PAGE_COST to 2 maybe 1.5. But probably there will not be impact to this query.


Thanks!

Regards,
--
Silvio Moioli
SUSE Manager Development Team


pgsql-performance by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Increasing work_mem slows down query, why?
Next
From: Tom Lane
Date:
Subject: Re: Increasing work_mem slows down query, why?