Quick Links

Re: FK triggers misused?

From:	cluster <skrald(at)amossen(dot)dk>
To:	pgsql-performance(at)postgresql(dot)org
Subject:	Re: FK triggers misused?
Date:	2007-04-16 23:12:28
Message-ID:	f00vq0$2ncr$1@news.hub.org
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-performance

> 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.

In response to

Re: FK triggers misused? at 2007-04-15 22:06:59 from Andrew - Supernews

Responses

Re: FK triggers misused? at 2007-04-16 23:49:56 from Tom Lane
Re: FK triggers misused? at 2007-04-16 23:55:06 from Tom Lane

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Tom Lane	2007-04-16 23:49:56	Re: FK triggers misused?
Previous Message	Alvaro Herrera	2007-04-16 23:01:04	Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance)