Re: Slow trigger on identical DB but different machine - Mailing list pgsql-general

From Etienne Labuschagne
Subject Re: Slow trigger on identical DB but different machine
Date
Msg-id 441E84A2.5020109@agileworks.net
Whole thread Raw
In response to Re: Slow trigger on identical DB but different machine  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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
>
>


pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: vacuum full taking much longer than dump + restore?
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Difference between "add column" and "add column" with default