> 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