On Tue, 6 Apr 2004, Nabil Sayegh wrote:
> Stephan Szabo wrote:
> > On Tue, 6 Apr 2004, Nabil Sayegh wrote:
> >
> >
> >>When I take the query of my first post and EXPLAIN ANALYZE it with 7.3 I get the following output:
> >>----------------------------------------------------------------------------------------------------
> >> Hash Join (cost=85.66..213.16 rows=1 width=240) (actual time=34.01..34.47 rows=1 loops=1)
> >
> >
> >>Now I tested it with 7.4 to see if gets faster, but guess what?
> >>It's about 40 times slower(!):
> >>
> >>----------------------------------------------------------------------------------------------------
> >> Merge Left Join (cost=142.22..142.28 rows=2 width=0) (actual time=18.681..18.684 rows=1 loops=1)
> >
> >
> > Hmm, this actual time number seems about 1/2 the above unless I'm missing
> > something (34 vs 19). Is it possible you missed some lines or something
> > while posting?
>
> I posted only the first few lines (it's repeating).
One other possibility is that the planning is taking a really long time.
How long do explain (non-analyze) on the two systems take? And how many
joins are there precisely?