Re: DBT-3 with SF=20 got failed

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