Re: [GENERAL] Slow trigger on identical DB but different machine

2006-03-21 Thread Etienne Labuschagne
Tom Lane wrote: Etienne Labuschagne [EMAIL PROTECTED] writes: 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). Have you

Re: [GENERAL] Slow trigger on identical DB but different machine

2006-03-20 Thread Etienne Labuschagne
Hi Tom, That was one of the first things I tried, to no avail . . . Regards Etienne Tom Lane wrote: Etienne Labuschagne [EMAIL PROTECTED] writes: 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

[GENERAL] Slow trigger on identical DB but different machine

2006-03-16 Thread Etienne Labuschagne
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