X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id A56DA9FA42B for ; Sun, 28 May 2006 13:05:04 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 34025-02 for ; Sun, 28 May 2006 13:04:58 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id F08649FA38E for ; Sun, 28 May 2006 13:04:58 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k4SG4r9f017734; Sun, 28 May 2006 12:04:53 -0400 (EDT) To: Greg Stark cc: Brendan Duddridge , PostgreSQL Performance Subject: Re: App very unresponsive while performing simple update In-reply-to: <874pzanvk6.fsf@stark.xeocode.com> References: <961F6F02-4B00-494C-B071-6DF76A305C14@clickspace.com> <21B15664-F4EE-462C-88B4-EEEB2B4A979F@clickspace.com> <874pzanvk6.fsf@stark.xeocode.com> Comments: In-reply-to Greg Stark message dated "28 May 2006 09:11:21 -0400" Date: Sun, 28 May 2006 12:04:52 -0400 Message-ID: <17733.1148832292@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/506 X-Sequence-Number: 19293 Greg Stark writes: > What queries are those two processes executing? And what foreign keys do you > have on the product table or elsewhere referring to the product table? And > what indexes do you have on those columns? And what PG version is this? Alvaro fixed the foreign-keys-take-exclusive-locks problem in 8.1 ... regards, tom lane