Re: Different query plans on same servers

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mario Splivalo <mario(dot)splivalo(at)megafon(dot)hr>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Different query plans on same servers
Date: 2011-12-06 20:00:49
Message-ID: 14289.1323201649@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Mario Splivalo <mario(dot)splivalo(at)megafon(dot)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).

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kevin Grittner 2011-12-06 20:17:30 Re: Different query plans on same servers
Previous Message Mario Splivalo 2011-12-06 19:48:10 Different query plans on same servers