Re: FK triggers misused?

From: cluster
Subject: Re: FK triggers misused?
Date: ,
Msg-id: f00vq0$2ncr$1@news.hub.org
(view: Whole thread, Raw)
In response to: Re: FK triggers misused?  (Andrew - Supernews)
Responses: Re: FK triggers misused?  (Tom Lane)
Re: FK triggers misused?  (Tom Lane)
List: pgsql-performance

Tree view

FK triggers misused?  (cluster, )
 Re: FK triggers misused?  (Tom Lane, )
 Re: FK triggers misused?  (Andrew - Supernews, )
  Re: FK triggers misused?  (Tom Lane, )
 Re: FK triggers misused?  (Andrew - Supernews, )
  Re: FK triggers misused?  (cluster, )
   Re: FK triggers misused?  (Tom Lane, )
   Re: FK triggers misused?  (Tom Lane, )
    Re: FK triggers misused?  (cluster, )
 Re: FK triggers misused?  (cluster, )
  Re: FK triggers misused?  (Stephan Szabo, )

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


pgsql-performance by date:

From: Tom Lane
Date:
Subject: Re: Fwd: Strangely Variable Query Performance
From: "Merlin Moncure"
Date:
Subject: Re: Basic Q on superfluous primary keys