Re: problem in select - Mailing list pgsql-general

From Stephan Szabo
Subject Re: problem in select
Date
Msg-id 20020913095023.Y58855-100000@megazone23.bigpanda.com
Whole thread Raw
In response to problem in select  ("frank_lupo" <frank_lupo@email.it>)
List pgsql-general
On Fri, 13 Sep 2002, [utf-8] frank_lupo wrote:

> This selection is more fast in ingres vs postgres
> Ingres 6.4    0.04 sec
> Postgres 7.2  0.42 sec

> select titolo,id,anno from ircalend where anno=2002 and id in(select
> distinct(idcalend) from ircalend_3) order by anno,titolo

See the FAQ, queries using IN (<subselect>) aren't implemented optimally,
a conversion to an EXISTS form may help.


pgsql-general by date:

Previous
From: "frank_lupo"
Date:
Subject: problem in select
Next
From: Richard Huxton
Date:
Subject: Re: problem in select