| 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: | Whole Thread | Raw Message | 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 |