Re: [GENERAL] vacuum: out of memory error

2006-11-28 Thread Vivek Khera
On Nov 28, 2006, at 8:40 AM, Jakub Ouhrabka wrote: There are 4G of RAM and 4G swap. and what is the per-process resource limit imposed by your OS? Just because your box has that much RAM doesn't mean your process is allowed to use it. smime.p7s Description: S/MIME cryptographic signatu

Re: [GENERAL] vacuum: out of memory error

2006-11-28 Thread Jakub Ouhrabka
Thanks for the responses! One thing I've forgotten: it's not reproducible. I can issue vacuum command manually without any problems few minutes/seconds after seeing the error message "out of memory" in the server log. I also can't find any corrupted rows manually. And for the listen/notify p

Re: [GENERAL] vacuum: out of memory error

2006-11-27 Thread Jim Nasby
On Nov 24, 2006, at 4:59 AM, Jakub Ouhrabka wrote: DETAIL: Failed on request of size 262143996. STATEMENT: VACUUM ANALYZE tablename There are few of them, always the same request size(?) but different two databases (out of 100+) and few different tables (pg_listener, pg_statistic and few s

Re: [GENERAL] vacuum: out of memory error

2006-11-27 Thread Andrew Sullivan
On Fri, Nov 24, 2006 at 11:59:16AM +0100, Jakub Ouhrabka wrote: > I've done little research in mailing list archives and I found possible > cause: table corruption caused by flaky hardware. Does it sound about > right? Are there any other possible causes? It sounds about right, yes; but the othe

[GENERAL] vacuum: out of memory error

2006-11-24 Thread Jakub Ouhrabka
Hi all, I have few of these messages in server log: ERROR: out of memory DETAIL: Failed on request of size 262143996. STATEMENT: VACUUM ANALYZE tablename There are few of them, always the same request size(?) but different two databases (out of 100+) and few different tables (pg_listener,