Re: Who can resolve this BUG ? - Mailing list pgsql-general

From Gregory Wood
Subject Re: Who can resolve this BUG ?
Date
Msg-id 004e01c0dfb5$3fbd9e80$7889ffcc@comstock.com
Whole thread Raw
In response to Who can resolve this BUG ?  (Alexander Dederer <dederer@spb.cityline.ru>)
List 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


pgsql-general by date:

Previous
From: larry a price
Date:
Subject: Re: debian packages for Postgresql 7.1 or higher ?
Next
From: Tom Lane
Date:
Subject: Re: Re: Performance aggregates