Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 03EDA9FB6B2
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Mon, 16 Apr 2007 20:11:08 -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 86435-03 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Mon, 16 Apr 2007 20:11:05 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2])
	by postgresql.org (Postfix) with ESMTP id 471BD9FB6A9
	for <pgsql-performance@postgresql.org>;
	Mon, 16 Apr 2007 20:11:05 -0300 (ADT)
Received: by floppy.pyrenet.fr (Postfix, from userid 106)
	id C01163090B; Tue, 17 Apr 2007 01:11:03 +0200 (MET DST)
From: cluster <skrald@amossen.dk>
X-Newsgroups: pgsql.performance
Subject: Re: FK triggers misused?
Date: Tue, 17 Apr 2007 01:12:28 +0200
Organization: Hub.Org Networking Services
Lines: 5
Message-ID: <f00vq0$2ncr$1@news.hub.org>
References: <evqm6g$29b1$1@news.hub.org> <26399.1176614941@sss.pgh.pa.us>
	<slrnf23eqp.10cj.andrew+nonews@atlantis.supernews.net>
	<102.1176650563@sss.pgh.pa.us>
	<slrnf258g3.10cj.andrew+nonews@atlantis.supernews.net>
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: <slrnf258g3.10cj.andrew+nonews@atlantis.supernews.net>
To: pgsql-performance@postgresql.org
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.026 tagged_above=0 required=5 tests=AWL=0.025,
	BAYES_50=0.001
X-Spam-Level: 
X-Archive-Number: 200704/319
X-Sequence-Number: 24196

> So the next question is, what pg version is the original poster using?
> because 8.1.x doesn't report trigger execution times, and 8.2.x would use
> a single bitmap index scan with an = ANY condition, not a BitmapOr.

I have tried 8.1.0 and 8.1.3 for this query.