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)
