Обсуждение: vacuumdb knowledge of prior vacuum
Does vacuumdb have knowledge of a VACUUM that was done on a table in the prior run and skip it the next time (assuming the table does not change) ? If not.is autovacuum smart enough to figure that out ?
Anj Adu escribió: > Does vacuumdb have knowledge of a VACUUM that was done on a table in > the prior run and skip it the next time (assuming the table does not > change) ? No. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.
How about if using autovacuum daemon instead?
Regards,
Husam
-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Alvaro Herrera
Sent: Monday, November 02, 2009 3:00 PM
To: Anj Adu
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] vacuumdb knowledge of prior vacuum
Anj Adu escribió:
> Does vacuumdb have knowledge of a VACUUM that was done on a table in
> the prior run and skip it the next time (assuming the table does not
> change) ?
No.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
******************************************************************************************
This message may contain confidential or proprietary information intended only for the use of the
addressee(s) named above or may contain information that is legally privileged. If you are
not the intended addressee, or the person responsible for delivering it to the intended addressee,
you are hereby notified that reading, disseminating, distributing or copying this message is strictly
prohibited. If you have received this message by mistake, please immediately notify us by
replying to the message and delete the original message and any copies immediately thereafter.
Thank you.
******************************************************************************************
FACLD
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.
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@commandprompt.com> 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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin >
Anj Adu escribió: > And autovacuum will reset the XID counter even if it skips tables > right? Just wanted to confirm before enabling autovacuum. On 8.2 and up, yes. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Oh..ok..then I guess I have to stick with vacuumdb -a (We are running 8.1.X ) Thank you On Mon, Nov 2, 2009 at 6:52 PM, Alvaro Herrera <alvherre@commandprompt.com> wrote: > Anj Adu escribió: >> And autovacuum will reset the XID counter even if it skips tables >> right? Just wanted to confirm before enabling autovacuum. > > On 8.2 and up, yes. > > -- > Alvaro Herrera http://www.CommandPrompt.com/ > PostgreSQL Replication, Consulting, Custom Development, 24x7 support >