Re: Do we need vacuuming when tables are regularly dropped?

From: "Peter Kovacs" <maxottovonstirlitz(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Do we need vacuuming when tables are regularly dropped?
Date: 2008-09-29 13:01:49
Message-ID: b6e8f2e80809290601o1b3cb5f5ge49f113673177a2a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Thank you!
Peter

On Mon, Sep 29, 2008 at 2:42 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Peter Kovacs" <maxottovonstirlitz(at)gmail(dot)com> writes:
>> It is not immediately clear from the documentation, but the VACUUM
>> command also deals with the system catalogs as well, correct?
>
> If it's run without any argument by a superuser, then yes.
>
> (I think in recent versions we also allow a non-superuser database owner
> to do this.)
>
> regards, tom lane
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message KKreuzer 2008-09-29 13:40:26 understand the process of ID wraparound
Previous Message Tom Lane 2008-09-29 12:42:00 Re: Do we need vacuuming when tables are regularly dropped?