And autovacuum will reset the XID counter even if it skips tables right? Just wanted to confirm before enabling autovacuum. Thanks Sriram On Mon, Nov 2, 2009 at 5:39 PM, Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> wrote: > Tomeh, Husam escribió: >> How about if using autovacuum daemon instead? > > Autovacuum only processes tables that need vacuuming, per the configured > parameters, so yes, it skips tables that were "recently" processed > (where "recently" is defined by said parameters and operations). > > -- > Alvaro Herrera http://www.CommandPrompt.com/ > The PostgreSQL Company - Command Prompt, Inc. > > -- > Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin > -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
