Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 205499FB709 for ; Tue, 17 Apr 2007 17:52:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 80192-08 for ; Tue, 17 Apr 2007 17:52:24 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id BAFA49FB4B8 for ; Tue, 17 Apr 2007 17:52:24 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 84C653090A; Tue, 17 Apr 2007 22:52:23 +0200 (MET DST) From: cluster X-Newsgroups: pgsql.performance Subject: Re: FK triggers misused? Date: Tue, 17 Apr 2007 22:53:51 +0200 Organization: Hub.Org Networking Services Lines: 4 Message-ID: References: <26399.1176614941@sss.pgh.pa.us> <102.1176650563@sss.pgh.pa.us> <12251.1176767706@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Thunderbird 1.5.0.10 (X11/20070306) In-Reply-To: <12251.1176767706@sss.pgh.pa.us> To: pgsql-performance@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.215 tagged_above=0 required=5 tests=AWL=0.214, BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200704/326 X-Sequence-Number: 24203 > Do the rows being updated contain > NULLs in the foreign-key columns? No, all FK columns are non-NULL. It is very strange.