Re: Slow trigger on identical DB but different machine

Hi Tom,

That was one of the first things I tried, to no avail . . .

Regards
Etienne

Tom Lane wrote:
> Etienne Labuschagne <elabuschagne@agileworks.net> 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 both DBs?  This sounds like either out-
> of-date stats or different configuration settings in the two.
>
>             regards, tom lane
>
>