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 vacuu

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 backu

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

2006-03-17 Thread Tom Lane
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 vacuumed and analyzed in bo