On 06/11/2015 09:53 AM, Kouhei Kaigai wrote:
>> curious: what was work_mem set to?
>>
> work_mem=48GB
>
> My machine mounts 256GB physical RAM.
work_mem can be allocated several times per backend. Nodes like sort and
hash_aggregate may each allocate that much. You should set work_mem to a
fraction of physical-RAM / concurrent-connections depending on the
complexity of your queries. 48GB does not sound reasonable.
Regards, Jan
--
Jan Wieck
Senior Software Engineer
http://slony.info