From: Scott Marlowe <scott.marlowe@gmail.com>
To: Ygor Degani <ygordegani@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: error vacuum full
Date: Mon, 5 Jan 2009 09:38:51 -0700
Message-ID: <dcc563d10901050838g68da0255k6b3845306279e8c2@mail.gmail.com> (raw)
In-Reply-To: <4bb7c9f80901050517l3743891ax93ad672a07054b14@mail.gmail.com>
References: <4bb7c9f80901050517l3743891ax93ad672a07054b14@mail.gmail.com>
On Mon, Jan 5, 2009 at 6:17 AM, Ygor Degani <ygordegani@gmail.com> wrote:
> I use postgres-8.3.5. My database has 168 GB in size. Whenever i try to do
> vacuum full happens the following error:
>
> WARNING: terminating connection because of crash of another server process
> DETAIL: The postmaster has commanded this server process to roll back the
> current transaction and exit, because another server process exited
> abnormally and possibly corrupted shared memory.
> HINT: In a moment you should be able to reconnect to the database and
> repeat your command.
> vacuumdb: vacuuming of database "acotel_brazil_vas" failed: server closed
> the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
>
> If i have autovacuum enabled, Do i need to do vacuum full?
You have two problems. One is you're running vacuum full regularly,
which you shouldn't need, and which can cause bloated indexes. Normal
autovacuum should handle your database fine unless you're deleting a
huge part of a table over and over.
As to why it's crashing, that's another story. Anything in the system
logs about the oom killer kicking in? Have you got work_mem set to
something huge? maintenance work mem really huge? shared_buffers,
etc? What have you changed from stock in postgresql.conf?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott.marlowe@gmail.com, ygordegani@gmail.com
Subject: Re: error vacuum full
In-Reply-To: <dcc563d10901050838g68da0255k6b3845306279e8c2@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox