X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D13A4539B5; Fri, 1 Apr 2005 21:53:50 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 53326-10; Fri, 1 Apr 2005 20:53:42 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id 378A7535F8; Fri, 1 Apr 2005 21:53:41 +0100 (BST) Received: from [192.168.1.52] (fc1smp [66.93.38.87]) by hosting.commandprompt.com (8.12.8/8.12.8) with ESMTP id j31Ko0kh010534; Fri, 1 Apr 2005 12:50:00 -0800 Subject: Re: Sustained inserts per sec ... ? From: "Joshua D. Drake" Reply-To: jd@commandprompt.com To: Christopher Petrilli Cc: Tom Lane , "Marc G. Fournier" , pgsql-performance@postgresql.org In-Reply-To: <59d991c4050401124638c4ab5d@mail.gmail.com> References: <20050401140421.P18194@ganymede.hub.org> <59d991c4050401113857086517@mail.gmail.com> <28353.1112388128@sss.pgh.pa.us> <59d991c4050401124638c4ab5d@mail.gmail.com> Content-Type: text/plain Organization: Joshua D. Drake Date: Fri, 01 Apr 2005 12:53:38 -0800 Message-Id: <1112388818.3487.34.camel@jd2.commandprompt.com> Mime-Version: 1.0 X-Mailer: Evolution 2.0.4 (2.0.4-2) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.03 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/17 X-Sequence-Number: 11414 > 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/