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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
Yes, I have vacuum-analyzed the DB to no avail . . .