Re: Vacuum on the database versus individual tables.

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: "Hartman, Matthew" <Matthew(dot)Hartman(at)krcc(dot)on(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Vacuum on the database versus individual tables.
Date: 2009-06-25 16:09:59
Message-ID: b42b73150906250909i1f208ee6s5e8160eb9238bff@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jun 25, 2009 at 10:40 AM, Hartman,
Matthew<Matthew(dot)Hartman(at)krcc(dot)on(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alan Hodgson 2009-06-25 16:11:07 Re: planned recovery from a certain transaction
Previous Message Hartman, Matthew 2009-06-25 16:05:59 Re: Vacuum on the database versus individual tables.