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 19DD03A3BF2 for ; Mon, 25 Oct 2004 22:20:13 +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 86237-04 for ; Mon, 25 Oct 2004 21:20:02 +0000 (GMT) Received: from tht.net (vista.tht.net [216.126.88.2]) by svr1.postgresql.org (Postfix) with ESMTP id 192C33A3B16 for ; Mon, 25 Oct 2004 22:20:01 +0100 (BST) Received: from [134.22.69.212] (dyn-69-212.tor.dsl.tht.net [134.22.69.212]) by tht.net (Postfix) with ESMTP id AB24676B17; Mon, 25 Oct 2004 17:19:59 -0400 (EDT) Subject: Re: can't handle large number of INSERT/UPDATEs From: Rod Taylor To: Anjan Dave Cc: Postgresql Performance In-Reply-To: <4BAFBB6B9CC46F41B2AD7D9F4BBAF7850985D5@vt-pe2550-001.vantage.vantage.com> References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF7850985D5@vt-pe2550-001.vantage.vantage.com> Content-Type: text/plain; charset=iso-8859-7 Message-Id: <1098739153.8557.333.camel@home> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 Date: Mon, 25 Oct 2004 17:19:14 -0400 Content-Transfer-Encoding: 8bit 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/425 X-Sequence-Number: 8901 On Mon, 2004-10-25 at 16:53, Anjan Dave wrote: > Hi, > > > > I am dealing with an app here that uses pg to handle a few thousand > concurrent web users. It seems that under heavy load, the INSERT and > UPDATE statements to one or two specific tables keep queuing up, to > the count of 150+ (one table has about 432K rows, other has about > 2.6Million rows), resulting in ¡wait¢s for other queries, and then This isn't an index issue, it's a locking issue. Sounds like you have a bunch of inserts and updates hitting the same rows over and over again. Eliminate that contention point, and you will have solved your problem. Free free to describe the processes involved, and we can help you do that.