Re: autovacuum question

[Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>]

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)