| From: | "Gregory Wood" <gregw(at)com-stock(dot)com> |
|---|---|
| To: | "Alexander Dederer" <dederer(at)spb(dot)cityline(dot)ru> |
| Cc: | "PostgreSQL-General" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Who can resolve this BUG ? |
| Date: | 2001-05-18 16:11:08 |
| Message-ID: | 004e01c0dfb5$3fbd9e80$7889ffcc@comstock.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
> 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?
http://www.ca.postgresql.org/docs/faq-english.html#4.23
Greg
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-05-18 16:12:07 | Re: Cost limit. |
| Previous Message | Stefan Huber | 2001-05-18 16:07:41 | Re: createdb -D /other/path dbname does not work |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc SCHAEFER | 2001-05-18 16:12:03 | Re: debian packages for Postgresql 7.1 or higher ? |
| Previous Message | Stephan Szabo | 2001-05-18 16:08:25 | Re: Problem while reading from some tables |