On 6/8/10 12:56 PM, "Tom Lane" <t...@sss.pgh.pa.us> wrote:
> Jeff Amiel <jam...@istreamimaging.com> writes:
>> On a side note, I am 100% sure that autovacuum was disabled when I brought
>> the database back up after the core dump(s). However, minutes after
>> restarting, some of my larger tables started getting vacuumed by pgsql user.
>> Any way that a vacuum would kick off for a particular table (or series of
>> tables) even when autovacuum was off in the postgresql.conf?
>
> Anti-transaction-wraparound vacuums, perhaps?
I would hope not. :)
This is postgres 8.2.X. Autovacuum has been enabled forever (seemingly with
no errors)
Anything I can look for ? (I searched the logs for references to "must be
vacuumed within" but found nothing....)
SELECT datname, age(datfrozenxid) FROM pg_database;
postgres 178649703
prod 204588751
template1 178653277
template0 178653131
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
