vacuumdb knowledge of prior vacuum

[Anj Adu]

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 ?

--
Sent via pgsql-admin mailing list (pgsql-admin@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

[Alvaro Herrera-7]

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@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

[Tomeh, Husam-2]

How about if using autovacuum daemon instead?

Regards,
      Husam


-----Original Message-----
From: pgsql-admin-owner@... [mailto:pgsql-admin-owner@...] On Behalf Of Alvaro Herrera
Sent: Monday, November 02, 2009 3:00 PM
To: Anj Adu
Cc: pgsql-admin@...
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@...)
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


--
Sent via pgsql-admin mailing list (pgsql-admin@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

[Alvaro Herrera-7]

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@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

[Anj Adu]

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@...> 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@...)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>

--
Sent via pgsql-admin mailing list (pgsql-admin@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

[Alvaro Herrera-7]

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

--
Sent via pgsql-admin mailing list (pgsql-admin@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

[Anj Adu]

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@...> 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
>

--
Sent via pgsql-admin mailing list (pgsql-admin@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin