Hi,
On Wednesday 04 March 2009 02:37:42 Scott Marlowe wrote:
> If some oddball query really needs a lot of work_mem,
> and benchmarks show something larger work_mem helps, consider raising
> the work_mem setting for that one query to something under 1G (way
> under 1G) That makes it noticeably faster. Don't allocate more than a
> test shows you helps.
The probably easiest way to integrate this into an existing application is
this way, in my experience:
BEGIN;
SET LOCAL work_mem TO '650MB';
SELECT -- the query requiring such a large setting
COMMIT;
Right after the commit the global configured work_mem (or the previous
session's one, in fact) will be in effect, you won't have to reset it yourself.
Regards,
--
dim