work_mem greater than 2GB issue

From: wickro <robwickert(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: work_mem greater than 2GB issue
Date: 2009-05-14 13:33:07
Message-ID: 66637189-1252-430f-901e-4f22c9137644@b1g2000vbc.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi everyone,

I have a largish table (> 8GB). I'm doing a very simple single group
by on. I am the only user of this database. If I set work mem to
anything under 2GB (e.g. 1900MB) the postmaster process stops at that
value while it's peforming it's group by. There is only one hash
operation so that is what I would expect. But anything larger and it
eats up all memory until it can't get anymore (around 7.5GB on a 8GB
machine). Has anyone experienced anything of this sort before.

Cheers

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2009-05-14 13:51:01 Re: postgresql on windows98
Previous Message Alvaro Herrera 2009-05-14 13:27:57 Re: Btree indizes, FILLFACTOR, vacuum_freeze_min_age and CLUSTER