| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Lane Van Ingen <lvaningen(at)esncc(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Need Some Suggestions |
| Date: | 2005-10-07 07:52:46 |
| Message-ID: | 4346294E.7080803@archonet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Lane Van Ingen wrote:
> I have an application that is prone to sudden, unscheduled high bursts of
> activity, and
> I am finding that the application design permits me to detect the activity
> bursts within
> an existing function. The bursts only affect 3 tables, but degradation
> becomes apparent
> after 2,000 updates, and significant after 8,000 updates.
Hmm - assuming your free-space settings are large enough, it might be
adequate to just run a vacuum on the 3 tables every 5 minutes or so. It
sounds like these are quite small tables with a lot of activity, so if
there's not much for vacuum to do it won't place too much load on your
system.
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Cestmir Hybl | 2005-10-07 09:24:05 | count(*) using index scan in "query often, update rarely" environment |
| Previous Message | Jeff Frost | 2005-10-06 23:55:27 | Status of Opteron vs Xeon |