From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Laszlo Nagy <gandalf@designaproduct.biz>
Cc: Jim Nasby <decibel@decibel.org>
Cc: pgsql-admin@postgresql.org
Subject: Re: autovacuum question
Date: Tue, 27 Mar 2007 13:06:29 -0400
Message-ID: <20070327170629.GA3966@alvh.no-ip.org> (raw)
In-Reply-To: <4608F3AE.8070002@designaproduct.biz>
References: <46080037.9020209@designaproduct.biz>
<3DD60E78-DAB8-49F6-A939-5C7C0E19C582@decibel.org>
<4608F3AE.8070002@designaproduct.biz>
Laszlo Nagy wrote:
> Jim Nasby írta:
> >Autovacuum doesn't launch a separate daemon; you'll only see an
> >autovac process when an autovac is actually working.
> Where should I see it? The output of "ps ax | grep auto" is empty. Does
> it mean that auto vacuum is not running? How can I check if there is a
> problem?
Do "show autovacuum", and it will tell you if autovac is running.
> >Also, 8.1 has code to prevent wraparound, so that's not it (see
> >backend/access/transam/varsup.c)
> Oh, then do you have any idea what caused this? E.g. a postgres client
> seeing an older version of the data? "Older" means that the postgres
> client was started today and it saw the data from 2 days ago, then
> suddenly it started to see the fresh data.
Maybe because they issued "commit" in the session where they had an idle
open transaction?
--
Alvaro Herrera http://www.PlanetPostgreSQL.org
"La libertad es como el dinero; el que no la sabe emplear la pierde" (Alvarez)
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: alvherre@alvh.no-ip.org, gandalf@designaproduct.biz, decibel@decibel.org
Subject: Re: autovacuum question
In-Reply-To: <20070327170629.GA3966@alvh.no-ip.org>
* 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