On 10/24/07, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
> "Giulio Cesare Solaroli" <giulio.cesare@xxxxxxxxx> writes:
> > How can I try to isolate the trigger taking so long, in oder to
> > understand which is/are the missing index(es)?
>
> Try SET CONSTRAINTS ALL IMMEDIATE and then EXPLAIN ANALYZE the
> delete. This should cause all the triggers to run within the
> scope of the EXPLAIN ANALYZE, and you'll be able to see which
> one(s) are slow. (This assumes you're running a recent release
> of PG; I think EXPLAIN shows trigger times since 8.1 or so.)
I was thinking about something similar after writing the last message.
Thank you very much for your attention!!
Giulio Cesare
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
