From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
---|---|
To: | Laszlo Nagy <gandalf(at)designaproduct(dot)biz> |
Cc: | Jim Nasby <decibel(at)decibel(dot)org>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: autovacuum question |
Date: | 2007-03-27 17:06:29 |
Message-ID: | 20070327170629.GA3966@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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)
From | Date | Subject | |
---|---|---|---|
Next Message | Alexander B. | 2007-03-27 19:32:39 | Strange behavior |
Previous Message | Shane Ambler | 2007-03-27 16:42:38 | Re: Problems with precompiled pgsql on mac |