Received: from mail01.edsamail.com.ph (mail01.edsamail.com.ph [210.16.71.2])
	by hub.org (8.9.3/8.9.3) with SMTP id VAA42582
	for <pgsql-admin@postgresql.org>; Wed, 31 May 2000 21:42:13 -0400 (EDT)
	(envelope-from brianb@edsamail.com)
Received: (qmail 10687 invoked by uid 508); 1 Jun 2000 01:41:27 -0000
Message-ID: <20000601014127.10685.qmail@mail01.edsamail.com.ph>
From: "brianb" <brianb-pgadmin@edsamail.com>
To: pgsql-admin@postgresql.org
Subject: Vacuum Question
Date: Thu, 01 Jun 2000 01:41:27 GMT
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200005/69


I have a Postgres application that must run 24x7. If postgres needs to be
vacuumed periodically, must I take the application offline, or is it enough
to disallow write (INSERT/UPDATE) access while allowing read access?

I hope it is the latter, as I have a large data set and there are
transactions going on all the time.

Brian
--
Brian Baquiran <brianb@edsamail.com>
http://www.baquiran.com/
AIM: bbaquiran