Postgres Pro
Downloads
Home   >   mailing lists

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

From Andrew Snow
Subject RE: safety of vacuum verbose analyze on active tables
Date
Msg-id NHEALMDKDACEIPBNOOOCEEGBCCAA.als@fl.net.au
Whole thread Raw
In response to safety of vacuum verbose analyze on active tables  (Jim Mercer <jim@reptiles.org>)
Responses Re: safety of vacuum verbose analyze on active tables  (Jim Mercer <jim@reptiles.org>)
List pgsql-general
Tree view 
> 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.


- Andrew

pgsql-general by date:

Previous
From: Jim Mercer
Date:
Subject: safety of vacuum verbose analyze on active tables
Next
From: Haroldo Stenger
Date:
Subject: Re: excell to postgres