Re: Vacuum on the database versus individual tables. - Mailing list pgsql-general

From Merlin Moncure
Subject Re: Vacuum on the database versus individual tables.
Date
Msg-id b42b73150906250909i1f208ee6s5e8160eb9238bff@mail.gmail.com
Whole thread Raw
In response to Vacuum on the database versus individual tables.  ("Hartman, Matthew" <Matthew.Hartman@krcc.on.ca>)
Responses Re: Vacuum on the database versus individual tables.
List pgsql-general
On Thu, Jun 25, 2009 at 10:40 AM, Hartman,
Matthew<Matthew.Hartman@krcc.on.ca> wrote:
> Good morning.
>
>
>
> On occasion I’ll perform a full vacuum on a database but will still receive
> a suggestion to vacuum an individual table immediately after. Does the full
> database vacuum not handle each individual table?

As of 8.3, for the most part you can trust autovacuum to do its thing
if it's enabled...there are exceptions to this but I'm curious why you
are doing 'vacuum full'.

merlin

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: planned recovery from a certain transaction
Next
From: Alan Hodgson
Date:
Subject: Re: planned recovery from a certain transaction