> > > 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.
You've got to be joking.
Is the table locking mechanism in Postgresql broken??