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

From Jim Mercer
Subject safety of vacuum verbose analyze on active tables
Date
Msg-id 20000417102202.F26070@reptiles.org
Whole thread Raw
Responses RE: safety of vacuum verbose analyze on active tables
Re: [HACKERS] safety of vacuum verbose analyze on active tables
List pgsql-general
i have always been cautious, and have tried to vacuum my tables when there
was little or no activity.

i now have a situation where that may not be possible any more.

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?

would it be safer to disable the update/insert processes?

--
[ Jim Mercer                 jim@reptiles.org              +1 416 506-0654 ]
[          Reptilian Research -- Longer Life through Colder Blood          ]
[  Don't be fooled by cheap Finnish imitations; BSD is the One True Code.  ]

pgsql-general by date:

Previous
From: "Martin A. Marques"
Date:
Subject: excell to postgres
Next
From: "Andrew Snow"
Date:
Subject: RE: safety of vacuum verbose analyze on active tables