Re: totally different plan when using partitions - Mailing list pgsql-general

From Tom Lane
Subject Re: totally different plan when using partitions
Date
Msg-id 24039.1250182118@sss.pgh.pa.us
Whole thread Raw
In response to Re: totally different plan when using partitions  (Richard Huxton <dev@archonet.com>)
Responses Re: totally different plan when using partitions  (Scara Maccai <m_lists@yahoo.it>)
Re: totally different plan when using partitions  (Scara Maccai <m_lists@yahoo.it>)
List pgsql-general
Richard Huxton <dev@archonet.com> writes:
> Scara Maccai wrote:
>> http://explain-analyze.info/query_plans/3817-query-plan-2525

> Ah, good - that's useful.

Hmmm ... why is the inner Nested Loop estimated to produce 30120 rows,
when the cartesian product of its inputs would only be 285 * 14 = 3990
rows?  What PG version is this, and can you extract a self-contained
test case with an equally silly estimate?

            regards, tom lane

pgsql-general by date:

Previous
From: Philip Rhoades
Date:
Subject: Re: PostgreSQL for Firefox Bookmarks?
Next
From: Sam Mason
Date:
Subject: Re: array syntax and geometric type syntax