The following bug has been logged on the website: Bug reference: 7580 Logged by: Maxim Boguk Email address: maxim.bo...@gmail.com PostgreSQL version: 9.2.1 Operating system: Linux Description:
create table t1 as select id from generate_series(1,100000) as g(id); create table t2 as select id from generate_series(1,100000) as g(id); alter table t1 add primary key (id); alter table t2 add primary key (id); analyze t1; analyze t2; explain select * from t1 left outer join ( select distinct t2.id from t2 where t2.id>100 ) as _t on _t.id=t1.id where (t1.id>100 or (t1.id<100 and _t.id IS NOT NULL)); The connection to the server was lost. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
