> What seems to happen is it slams into a "wall" of some sort, the
> system goes into disk write frenzy (wait=90% CPU), and eventually
> recovers and starts running for a while at a more normal speed.  What
> I need though, is to not have that wall happen.  It is easier for me
> to accept a constant degredation of 5%, rather than a 99% degredation
> for short periods, as it can cause cascade problems in the system.

Could this possibly be a checkpoint happening?

Also how many checkpoint segments do you have?

> My goal is to gather some numbers, and post code + schema + analysis.
> Chris
Command Prompt, Inc., Your PostgreSQL solutions company. 503-667-4564
Custom programming, 24x7 support, managed services, and hosting
Open Source Authors: plPHP, pgManage, Co-Authors: plPerlNG
Reliable replication, Mammoth Replicator - http://www.commandprompt.com/

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to