Who can resolve this BUG ?

From: Alexander Dederer <dederer(at)spb(dot)cityline(dot)ru>
To: pgsql-admin(at)postgresql(dot)org(dot)pgsql-general(at)postgresql(dot)org
Subject: Who can resolve this BUG ?
Date: 2001-05-17 05:37:22
Message-ID: 9dvnup$2n3q$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

INM1=# explain select ref_num from grls where ag_id in (24);
Index Scan using grls_ag_id on grls (cost=0.00..597.87 rows=849 width=12)

IMN1=# explain select ref_num from grls where ag_id in (select 24);
Seq Scan on grls (cost=0.00..992.44 rows=30195 width=12)
SubPlan
-> Materialize (cost=0.00..0.00 rows=0 width=0)
-> Result (cost=0.00..0.00 rows=0 width=0)

IMN1=# explain select ref_num from grls where ag_id = (select 24);
Index Scan using grls_ag_id on grls (cost=0.00..597.87 rows=849 width=12)
InitPlan
-> Result (cost=0.00..0.00 rows=0 width=0)

". . . in (24) " work in 35 faster than ". . . in (select 24)". In the
last don't use indices for increase perfomans.
It's been normaly work in PostgreSQL version 7.2 ? Or not?

P.S.
Sorry my English.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Johan Segernäs 2001-05-17 07:07:40 Importing data from ms-sql
Previous Message John Pagakis 2001-05-16 23:34:31 RE: Question / Joel /BE

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-05-17 05:52:30 Re: Newbe questions: Setting Passwords
Previous Message John Clark Naldoza y Lopez 2001-05-17 05:20:43 Re: Newbe questions: Setting Passwords