X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 79ED85E46EC for ; Wed, 25 Aug 2004 16:16:35 -0300 (ADT) 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 05727-09 for ; Wed, 25 Aug 2004 19:16:32 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 632855E46C2 for ; Wed, 25 Aug 2004 16:16:31 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i7PJGWp3002191; Wed, 25 Aug 2004 15:16:32 -0400 (EDT) To: Steve Lane Cc: pgsql-admin@postgresql.org, Jamie Thomas Subject: Re: Odd query behavior [urgent, but long] In-reply-to: References: Comments: In-reply-to Steve Lane message dated "Wed, 25 Aug 2004 12:06:42 -0500" Date: Wed, 25 Aug 2004 15:16:32 -0400 Message-ID: <2190.1093461392@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: 200408/247 X-Sequence-Number: 14642 Steve Lane writes: > I have enabled pretty extensive query logging on the 7.1.3 instance. What I > see is that certain queries take hideously long. Tell us about foreign keys associated with the table being updated? An UPDATE would fire triggers for both referencing and referenced keys ... I'm suspecting an unindexed or datatype-incompatible foreign key column. regards, tom lane