| From: | "Little, Douglas" <DOUGLAS(dot)LITTLE(at)orbitz(dot)com> |
|---|---|
| To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Forced quiesce |
| Date: | 2010-10-28 12:39:19 |
| Message-ID: | 8585BA53443004458E0BAA6134C5A7FB4773E160@EGEXCMB01.oww.root.lcl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi,
We're having to vacuum full the system tables everyday due to the number of temp table drop/creates.
We're finding that if anyone tries to execute a job during the maintenance period, it often hangs the db.
Is there a way that we can force the db to quiesce? Or lock out users.
Luckly, most users are coming in thru a network VIP, so all client IP's are the same.
Thanks in advance.
Doug Little
Sr. Data Warehouse Architect | Enterprise Data Management | Orbitz Worldwide
500 W. Madison, Suite 1000 Chicago IL 60661| Office 312.260.2588 | Fax 312.894.5164 | Cell 847-997-5741
Douglas(dot)Little(at)orbitz(dot)com<mailto:Douglas(dot)Little(at)orbitz(dot)com>
[cid:image001(dot)jpg(at)01CB7672(dot)03458C70] orbitz.com<http://www.orbitz.com/> | ebookers.com<http://www.ebookers.com/> | hotelclub.com<http://www.hotelclub.com/> | cheaptickets.com<http://www.cheaptickets.com/> | ratestogo.com<http://www.ratestogo.com/> | asiahotels.com<http://www.asiahotels.com/>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Plugge, Joe R. | 2010-10-28 12:45:04 | Re: Forced quiesce |
| Previous Message | Gnanakumar | 2010-10-28 07:57:02 | Re: pg_ctl: server does not shut down |