Re: vacuum full...

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Jessica Richard <rjessil(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: vacuum full...
Date: 2009-02-19 16:37:57
Message-ID: dcc563d10902190837r3a528793p29b6e2245ce99208@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, Feb 19, 2009 at 9:35 AM, Jessica Richard <rjessil(at)yahoo(dot)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?

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rafael Domiciano 2009-02-19 18:01:56 Re: vacuum full...
Previous Message Jessica Richard 2009-02-19 16:35:15 vacuum full...