From: Richard Huxton <dev@archonet.com>
To: Lane Van Ingen <lvaningen@esncc.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Need Some Suggestions
Date: Fri, 07 Oct 2005 08:52:46 +0100
Message-ID: <4346294E.7080803@archonet.com> (raw)
In-Reply-To: <EKEMKEFLOMKDDLIALABIMEHACDAA.lvaningen@esncc.com>
References: <EKEMKEFLOMKDDLIALABIMEHACDAA.lvaningen@esncc.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dev@archonet.com, lvaningen@esncc.com
Subject: Re: Need Some Suggestions
In-Reply-To: <4346294E.7080803@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox