Hi all,
I have the exact same DB on two machines. One is a RedHat box with a
SAN for storage. The other is a Windows XP laptop.
The RedHat box outperforms the laptop with everything (as expected)
except with a DELETE FROM query (quite unexpected).
After doing a EXPLAIN ANALYZE, it seems that a trigger (on delete)
function is causing the delay (the trigger is implemented in pgSQL).
I'm not sure how to analyze the parts "inside" the trigger to see which
operation is causing the problem.
The strange thing is that both databases are EXACTLY the same with
EXACTLY the same SQL query executed (I restore both DBs from the same
backup file to ensure that everything is the same - data and objects).
Why wouldn't the trigger cause the same problem on the Windows XP
laptop? The RedHat machine takes about 100x longer to do the operation
than the laptop!
How can I log/analyze the operations inside a trigger and are there any
suggestions as to why the trigger would be so slow?
Any help would be greatly appreciated.
Etienne
