Daniel Grace <dgrace(at)wingsnw(dot)com> writes:
> So I've spent the greater portion of the last two hours trying to slim
> down the schema and query enough to provide something that can
> reproduce this.
> While I can reproduce it 100% of the time with live data, I can't get
> it to reproduce at all with test data -- though I've included a few
> schemas below. It seems to be based on what plan ends up being
> constructed for the query.
Maybe you could force it for the test data with some suitable
combination of the enable_plantype switches.
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Robert Haas||Date: 2010-07-09 19:49:58|
|Subject: Re: BUG #5539: Generally incorrect planner estimations on join with UNION ALL|
|Previous:||From: Daniel Grace||Date: 2010-07-09 17:56:13|
|Subject: Re: BUG #5548: ERROR: invalid attnum ## for rangetable entry on EXPLAIN VERBOSE, not on EXPLAIN|