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

Anj Adu escribi=F3:
> 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.co=
m/
The PostgreSQL Company - Command Prompt, Inc.

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

How about if using autovacuum daemon instead?

Regards,
Husam


-----Original Message-----
From: pgsql-admin-owner [at] postgresql.org [mailto:pgsql-admin-owner [at] postgresql=
..org] On Behalf Of Alvaro Herrera
Sent: Monday, November 02, 2009 3:00 PM
To: Anj Adu
Cc: pgsql-admin [at] postgresql.org
Subject: Re: [ADMIN] vacuumdb knowledge of prior vacuum

Anj Adu escribi=F3:
> 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 [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
************************************************************ ***************=
***************
This message may contain confidential or proprietary information intended o=
nly for the use of the
addressee(s) named above or may contain information that is legally privile=
ged. 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 copyin=
g this message is strictly
prohibited. If you have received this message by mistake, please immediatel=
y notify us by
replying to the message and delete the original message and any copies imme=
diately thereafter.

Thank you.
************************************************************ ***************=
***************
FACLD


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

Tomeh, Husam escribi=F3:
> 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.co=
m/
The PostgreSQL Company - Command Prompt, Inc.

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

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 [at] commandprompt.com> wrote:
> Tomeh, Husam escribi=F3:
>> 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 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0http://www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>

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

Anj Adu escribi=F3:
> 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.co=
m/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

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

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 [at] commandprompt.com> wrote:
> Anj Adu escribi=F3:
>> 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 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0http://www.CommandPrompt.com/
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
>

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