Re: safety of vacuum verbose analyze on active tables

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