RE: safety of vacuum verbose analyze on active tables

From: "Andrew Snow" <als(at)fl(dot)net(dot)au>
To: "Pgsql-General(at)Postgresql(dot) Org" <pgsql-general(at)postgresql(dot)org>
Subject: RE: safety of vacuum verbose analyze on active tables
Date: 2000-04-17 14:58:58
Message-ID: NHEALMDKDACEIPBNOOOCEEGBCCAA.als@fl.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Haroldo Stenger 2000-04-17 15:01:41 Re: excell to postgres
Previous Message Manuel Lemos 2000-04-17 14:56:26 Re: Connecting website with SQL-database.....