| From: | Laszlo Nagy <gandalf(at)designaproduct(dot)biz> |
|---|---|
| To: | Jim Nasby <decibel(at)decibel(dot)org>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: autovacuum question |
| Date: | 2007-03-27 10:36:30 |
| Message-ID: | 4608F3AE.8070002@designaproduct.biz |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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?
>
> 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.
Thanks,
Laszlo
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2007-03-27 13:06:38 | Re: [GENERAL] ERROR: out of shared memory |
| Previous Message | Peter Elmers | 2007-03-27 08:40:36 | Re: Problems with precompiled pgsql on mac |