Unfortunately there's no very simple way to determine which FK is the
problem. (In 8.1 it'll be possible to do that with EXPLAIN ANALYZE,
but in existing releases EXPLAIN doesn't break out the time spent in
each trigger ...) You have to just eyeball the schema :-(.
phpPgAdmin has a handy info feature where you can see all tables that
refer to the current one. You can always go and steal that query to
find them...
Chris
---------------------------(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
