Re: [BUGS] BUG #5539: Generally incorrect planner estimations on join with UNION ALL

2010-07-09 Thread Robert Haas
On Sat, Jul 3, 2010 at 8:47 PM, Maksym Boguk wrote: > notable planner had correctly estimated amount of rows in one side of the > join: > (Append  (cost=0.00..0.98 rows=2 width=4)) > and planner hard correctly estimated amount of rows in the another side of > the join: > Index Scan using t3_value_

[BUGS] BUG #5539: Generally incorrect planner estimations on join with UNION ALL

2010-07-03 Thread Maksym Boguk
The following bug has been logged online: Bug reference: 5539 Logged by: Maksym Boguk Email address: maxim.bo...@gmail.com PostgreSQL version: 8.4.3 Operating system: FreeBSD 7.2 Description:Generally incorrect planner estimations on join with UNION ALL Details: If