From: | "hubert depesz lubaczewski" <depesz(at)gmail(dot)com> |
---|---|
To: | Angva <angvaw(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: out of memory woes |
Date: | 2006-12-19 07:48:18 |
Message-ID: | 9e4684ce0612182348p1ee1ad12p1414c877b77dd9b3@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 18 Dec 2006 07:16:56 -0800, Angva <angvaw(at)gmail(dot)com> wrote:
>
> The funny thing is that once it does fail, it fails consistently until
> the server is bounced - I must have run the cluster script 10 times
> after the initial failure. The server's 6g of RAM is normally more than
> enough (so normally, maintenance_work_mem is not too high) until this
> strange wall is hit. Another funny thing is that according to top, no
> more than about 700k of swap is ever used - even when the problem
> occurs - and the limit is 2g.
>
could you please show the configure options (shared buffers, work mem, and
maintenance_work_mem), plus; what os you are running and on what
architecture? i.e. 32bit? 64bit? xeon?
best regards,
depesz
--
http://www.depesz.com/ - nowy, lepszy depesz
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Amiel | 2006-12-19 08:17:40 | FreeBSD 6.0 PostgreSQL upgrade |
Previous Message | Zoltan Boszormenyi | 2006-12-19 07:43:23 | Re: 8.2.0 Tarball vs. REL8_2_0 vs. REL8_2_STABLE |