The following bug has been logged on the website:
Bug reference: 7556
Logged by: lt
Email address: [email protected]
PostgreSQL version: 9.2.0
Operating system: windows xp
Description:
test=# create table sli_test (id int primary key,info varchar(20));
test=# insert into sli_test select
generate_series(1,1000000),'digoal'||generate_series(1,1000000);
test=# analyze verbose sli_test;
test=# create table sli_test2 (id int not null,info varchar(20));
test=# insert into sli_test2 select
generate_series(1,1000000),'dbase'||generate_series(1,1000000);
test=# analyze verbose sli_test2;
test=# explain select max(a.info)from sli_test a where a.id not in(select
b.id from sli_test2 b where b.id<50000);
QUERY PLAN
---------------------------------------------------------------------------------------
Aggregate (cost=9241443774.00..9241443774.01 rows=1 width=12)
--
Sent via pgsql-bugs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
