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.
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 |
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 |