Re: vacuum full... - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: vacuum full...
Date
Msg-id dcc563d10902190837r3a528793p29b6e2245ce99208@mail.gmail.com
Whole thread Raw
In response to vacuum full...  (Jessica Richard <rjessil@yahoo.com>)
Responses Re: vacuum full...  (Rafael Domiciano <rafael.domiciano@gmail.com>)
List pgsql-admin
On Thu, Feb 19, 2009 at 9:35 AM, Jessica Richard <rjessil@yahoo.com> wrote:
> I am running "vacuum full" via a shell script for a list of large databases
> now... and I may run out of my scheduled system down time....
>
> If I don't finish all databases and kill the script in the middle... am I
> going to cause any table corruptions since "vacuum full" is rebuilding the
> tables and indexes....

No.  But may I ask why you are running vacuum full?  Is it a regular
thing.  Do all your tables in all your dbs actually need it?

pgsql-admin by date:

Previous
From: Jessica Richard
Date:
Subject: vacuum full...
Next
From: Rafael Domiciano
Date:
Subject: Re: vacuum full...