From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | frank_lupo <frank_lupo(at)email(dot)it> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: query slow problem |
Date: | 2002-07-29 16:23:43 |
Message-ID: | 20020729092232.M93417-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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)
From | Date | Subject | |
---|---|---|---|
Next Message | Markus Wollny | 2002-07-29 16:29:13 | Re: tsearch - Regression tests fail |
Previous Message | frank_lupo | 2002-07-29 16:13:13 | Re: query slow problem |