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
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
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
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
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,