Vacuum Question

From: "brianb" <brianb-pgadmin(at)edsamail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Vacuum Question
Date: 2000-06-01 01:41:27
Message-ID: 20000601014127.10685.qmail@mail01.edsamail.com.ph
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)edsamail(dot)com>
http://www.baquiran.com/
AIM: bbaquiran

Browse pgsql-admin by date

  From Date Subject
Next Message Ohgaki Yasuo 2000-06-01 01:58:32 Re: Database/table limits ??????
Previous Message LeSI 2000-06-01 01:25:18 pgsql 7 in alpha