safety of vacuum verbose analyze on active tables

From: Jim Mercer <jim(at)reptiles(dot)org>
To: pgsql-hackers(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: safety of vacuum verbose analyze on active tables
Date: 2000-04-17 14:22:02
Message-ID: 20000417102202.F26070@reptiles.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)reptiles(dot)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. ]

Responses

Browse pgsql-general by date

  From Date Subject
Next Message J.Post 2000-04-17 14:26:41 Connecting website with SQL-database.....
Previous Message Martin A. Marques 2000-04-17 14:16:27 excell to postgres