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 A208C3A44A8 for ; Tue, 26 Oct 2004 22:53:23 +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 59001-04 for ; Tue, 26 Oct 2004 21:53:12 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id C92BE3A44CE for ; Tue, 26 Oct 2004 22:53:14 +0100 (BST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id i9QLrE4h013824; Tue, 26 Oct 2004 17:53:14 -0400 (EDT) To: "Anjan Dave" Cc: "Rod Taylor" , "Postgresql Performance" Subject: Re: can't handle large number of INSERT/UPDATEs In-reply-to: <4BAFBB6B9CC46F41B2AD7D9F4BBAF7850985DD@vt-pe2550-001.vantage.vantage.com> References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF7850985DD@vt-pe2550-001.vantage.vantage.com> Comments: In-reply-to "Anjan Dave" message dated "Tue, 26 Oct 2004 13:56:25 -0400" Date: Tue, 26 Oct 2004 17:53:14 -0400 Message-ID: <13823.1098827594@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/441 X-Sequence-Number: 8917 "Anjan Dave" writes: > None of the locks are in state false actually. In that case you don't have a locking problem. > I don't have iostat on that machine, but vmstat shows a lot of writes to > the drives, and the runnable processes are more than 1: I get the impression that you are just saturating the write bandwidth of your disk :-( It's fairly likely that this happens during checkpoints. Look to see if the postmaster has a child that shows itself as a checkpointer in "ps" when the saturation is occurring. You might be able to improve matters by altering the checkpoint frequency parameters (though beware that either too small or too large will likely make matters even worse). regards, tom lane