Re: vacuumdb knowledge of prior vacuum

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: "Tomeh, Husam" <HTomeh(at)facorelogic(dot)com>
Cc: Anj Adu <fotographs(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: vacuumdb knowledge of prior vacuum
Date: 2009-11-03 01:39:26
Message-ID: 20091103013926.GI4617@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Hengky Lie 2009-11-03 01:55:06 Please Help... Service fails to start
Previous Message Tomeh, Husam 2009-11-03 00:14:30 Re: vacuumdb knowledge of prior vacuum