Vacuum Question - Mailing list pgsql-general

From brianb
Subject Vacuum Question
Date
Msg-id 20000601091701.631.qmail@mail01.edsamail.com.ph
Whole thread Raw
Responses Re: Vacuum Question  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: Vacuum Question  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I have a Postgres application that must run 24x7. If postgres needs to be
vacuumed periodically, must I take the application offline completely, 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 amount of data and there are
transactions going on all the time.

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

pgsql-general by date:

Previous
From: Thomas Good
Date:
Subject: Re: Perl interfaces?
Next
From: "Adam Walczykiewicz"
Date:
Subject: textpos() in postgreSQL 7.0