Re: Different query plans on same servers - Mailing list pgsql-performance

From Mario Splivalo
Subject Re: Different query plans on same servers
Date
Msg-id 4EDEB21D.3030703@megafon.hr
Whole thread Raw
In response to Re: Different query plans on same servers  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
On 12/06/2011 09:00 PM, Tom Lane wrote:
> Mario Splivalo <mario.splivalo@megafon.hr> writes:
>> I have 8.4.8 on producion and 8.4.9 on test, could that explain the
>> difference in plans chosen?
>
> I'd wonder first if you have the same statistics settings on both.
> The big problem here is that the estimation of the join size is bad
> (8588 versus 0).

They do, I guess. I did rsync postgres datadir from the prod server to
the test server. The only difference is that prod server was a bit more
loaded than the test server.

    Mario

pgsql-performance by date:

Previous
From: Havasvölgyi Ottó
Date:
Subject: Response time increases over time
Next
From: Mario Splivalo
Date:
Subject: Re: Different query plans on same servers