From: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | vacuumdb out of memory error |
Date: | 2006-02-15 16:58:49 |
Message-ID: | 43F35DC9.30603@zeut.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello all,
I run a nightly "vacuumdb -a -z" on my production server. The output of
the command is emailed to me every night. Today while checking my email
I received this:
vacuumdb: vacuuming database "postgres"
vacuumdb: vacuuming of database "postgres" failed: ERROR: out of memory
DETAIL: Failed on request of size 167772156.
Now this concerned me because I know that vacuum errors are often the
sign of data corruption, however the postgres database on my server has
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?
Thanks,
Matt
ps: Some details:
I run autovacuum, but do the nightly vacuumdb as a sort of poor man's
maintenance window.
postgres=# select version();
version
-------------------------------------------------------------------------------------------------------------
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)
From | Date | Subject | |
---|---|---|---|
Next Message | Bart Golda | 2006-02-15 17:00:11 | Connecting process to PostgreSQL works stunningly slow |
Previous Message | Martijn van Oosterhout | 2006-02-15 16:33:04 | Re: Does PG really lack a time zone for India? |