On 12/06/2011 09:00 PM, Tom Lane wrote:
Mario Splivalo mario.spliv...@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
I have a fairly simple query:
SELECT some columns
FROM tubesite_image
INNER JOIN tubesite_object
ON (tubesite_image.object_ptr_id = tubesite_object.id)
WHERE
tubesite_object.site_id = 8
ORDER BY
tubesite_object.pub_date ASC LIMIT 21;
That query is having a bad query
Mario Splivalo mario.spliv...@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
Tom Lane t...@sss.pgh.pa.us wrote:
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).
But both servers develop that estimate for the join size. I was
wondering more about whether the
Kevin Grittner kevin.gritt...@wicourts.gov wrote:
But both servers develop that estimate for the join size.
[sigh] Those *were* both from the production server. Please show
us the EXPLAIN ANALYZE from the other server.
-Kevin
--
Sent via pgsql-performance mailing list
On 12/06/2011 09:00 PM, Tom Lane wrote:
Mario Splivalo mario.spliv...@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
On 12/06/2011 09:17 PM, Kevin Grittner wrote:
The hash join path must look more expensive on the first machine,
for some reason.
Mario, could you post the result of running this query from both
servers?:
http://wiki.postgresql.org/wiki/Server_Configuration
Sure. Here is from the
On 12/06/2011 09:29 PM, Kevin Grittner wrote:
Kevin Grittner kevin.gritt...@wicourts.gov wrote:
But both servers develop that estimate for the join size.
[sigh] Those *were* both from the production server. Please show
us the EXPLAIN ANALYZE from the other server.
Huh, right... missed