Re: safety of vacuum verbose analyze on active tables - Mailing list pgsql-general

From Ed Loehr
Subject Re: safety of vacuum verbose analyze on active tables
Date
Msg-id 38FB2E66.3CC2C1A5@austin.rr.com
Whole thread Raw
In response to RE: safety of vacuum verbose analyze on active tables  ("Andrew Snow" <als@fl.net.au>)
Responses RE: safety of vacuum verbose analyze on active tables
List pgsql-general
Andrew Snow wrote:
>
> > what is the relative safety of doing a vacuum verbose analyze on a 24Gb
> > table while there are selects and updates/inserts happening on it?
>
> As far as I know, the table is locked completely during a Vacuum. Any
> transactions attempting to do inserts/updates will be paused safely. So go
> ahead and schedule your vacuums for whenever you need to.

There have been reports of problems (corruption, etc.) when trying to do
this.  See the archive for a discussion along these lines a few months ago.

Regards,
Ed Loehr

pgsql-general by date:

Previous
From: Jim Mercer
Date:
Subject: Re: safety of vacuum verbose analyze on active tables
Next
From: "Andrew Snow"
Date:
Subject: RE: safety of vacuum verbose analyze on active tables