Skip site navigation (1) Skip section navigation (2)

BUG #7556: "select not in sub query" plan very poor vs "not exists"

From: l1t(at)tom(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #7556: "select not in sub query" plan very poor vs "not exists"
Date: 2012-09-19 05:48:08
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
The following bug has been logged on the website:

Bug reference:      7556
Logged by:          lt
Email address:      l1t(at)tom(dot)com
PostgreSQL version: 9.2.0
Operating system:   windows xp

test=# create table sli_test (id int primary key,info varchar(20));
test=# insert into sli_test select
test=# analyze verbose sli_test;
test=# create table sli_test2 (id int not null,info varchar(20));
test=#  insert into sli_test2 select
test=# analyze verbose sli_test2;
test=# explain select max( sli_test a where not in(select from sli_test2 b where<50000);
                                      QUERY PLAN
 Aggregate  (cost=9241443774.00..9241443774.01 rows=1 width=12)


pgsql-bugs by date

Next:From: Stuart BishopDate: 2012-09-19 08:06:03
Subject: Re: BUG #7546: Backups on hot standby cancelled despite hot_standby_feedback=on
Previous:From: Craig RingerDate: 2012-09-19 05:31:07
Subject: Re: Postgres JDBC-hibernate Problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group