On Wed, Aug 18, 2010 at 11:45 PM, Samuel Gendler
> Answered my own question. Cranking work_mem up to 350MB revealed that
> the in-memory sort requires more memory than the disk sort.
Note that unless you run VERY few client connections, it's usually
better to leave work_mem somewhere in the 1 to 32Meg range and have
the connection or user or database that needs 350Meg be set there.
alter user memoryhog set work_mem='512MB';
alter database memhogdb set work_mem='512MB';
In response to
pgsql-performance by date
|Next:||From: Samuel Gendler||Date: 2010-08-19 06:38:50|
|Subject: Re: in-memory sorting|
|Previous:||From: Samuel Gendler||Date: 2010-08-19 06:14:10|
|Subject: yet another q|