Re: query slow problem

On Mon, 29 Jul 2002, frank_lupo wrote:

> >
> > 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;

> My problem is not resolved.

What do those give you as explain analyze results? (And the distinct on
varient that someone else sent - forgot about that posibility)



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx