Richard Huxton <dev@xxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
