Re: query slow problem

On Mon, 29 Jul 2002, frank_lupo wrote:

> select id,de2 from irtab where id in (select distinct(ruolofunz) from
> irelbtes_1 where entpian=118331)\g

In optimizes poorly currently in postgres, so you're generally better
off converting to EXISTS or subselect in FROM. Something like
(untested):

select id, de2 from irtabl where exists (select 1 from
irelbtes_1 where entpian=118331 and irtabl.id=ruolofunz)

or

select id, de2 from irtabl, (select distinct(ruolofunz) as r from
irelbtes_1 where entpian=118331) as i
where i.r=irtabl.id;