Re: Slow trigger on identical DB but different machine

From: Etienne Labuschagne <elabuschagne(at)agileworks(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Slow trigger on identical DB but different machine
Date: 2006-03-20 10:32:02
Message-ID: 441E84A2.5020109@agileworks.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Tom,

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

Regards
Etienne

Tom Lane wrote:
> Etienne Labuschagne <elabuschagne(at)agileworks(dot)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
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-03-20 10:41:18 Re: Difference between "add column" and "add column" with default
Previous Message Martijn van Oosterhout 2006-03-20 10:24:48 Re: vacuum full taking much longer than dump + restore?