Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Slow trigger on identical DB but different machine
Date
Msg-id 28669.1142607011@sss.pgh.pa.us
Whole thread Raw
In response to Slow trigger on identical DB but different machine  (Etienne Labuschagne <elabuschagne@agileworks.net>)
Responses Re: Slow trigger on identical DB but different machine  (Etienne Labuschagne <elabuschagne@agileworks.net>)
Re: Slow trigger on identical DB but different machine  (Etienne Labuschagne <elabuschagne@agileworks.net>)
List pgsql-general
Tree view 
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: TJ O'Donnell
Date:
Subject: efficiency of group by 1 order by 1
Next
From: Tom Lane
Date:
Subject: Re: after insert trigger hangs