Re: vacuumdb out of memory error - Mailing list pgsql-general

From Tom Lane
Subject Re: vacuumdb out of memory error
Date
Msg-id 14663.1140025605@sss.pgh.pa.us
Whole thread Raw
In response to vacuumdb out of memory error  ("Matthew T. O'Connor" <matthew@zeut.net>)
Responses Re: vacuumdb out of memory error  ("Matthew T. O'Connor" <matthew@zeut.net>)
List pgsql-general
"Matthew T. O'Connor" <matthew@zeut.net> writes:
> no tables in it.  I logged into my server and reran the vacuumdb -a -z
> command and it went though with no problem.  I also checked my log file
> and it shows that there have been 25 out of memory errors on my server
> today.

> My question is:  Is this normal?  Should this make me nervous that I
> have a problem?

Yeah ...

>  PostgreSQL 8.1.0 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC)
> 3.3.3 20040412 (Red Hat Linux 3.3.3-7)

... and this should definitely make you nervous.  We don't release
update versions for idle amusement.  Get onto 8.1.3 and see if it keeps
happening.

            regards, tom lane

pgsql-general by date:

Previous
From: Brendan Duddridge
Date:
Subject: Re: indexes for ILIKE
Next
From: "Matthew T. O'Connor"
Date:
Subject: Re: vacuumdb out of memory error