Re: vacuumdb out of memory error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: vacuumdb out of memory error
Date: 2006-02-15 17:46:45
Message-ID: 14663.1140025605@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Matthew T. O'Connor" <matthew(at)zeut(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matthew T. O'Connor 2006-02-15 17:48:50 Re: vacuumdb out of memory error
Previous Message Brendan Duddridge 2006-02-15 17:40:39 Re: indexes for ILIKE