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.