Vacuum Question - Mailing list pgsql-admin

From brianb
Subject Vacuum Question
Date
Msg-id 20000601014127.10685.qmail@mail01.edsamail.com.ph
Whole thread Raw
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Database/table limits ??????
Next
From: "Ohgaki Yasuo"
Date:
Subject: Re: Database/table limits ??????