Re: 7.3.1 New install, large queries are slow - Mailing list pgsql-performance

From Tom Lane
Subject Re: 7.3.1 New install, large queries are slow
Date
Msg-id 15059.1042731982@sss.pgh.pa.us
Whole thread Raw
In response to Re: 7.3.1 New install, large queries are slow  (Kevin Brown <kevin@sysexperts.com>)
List pgsql-performance
Kevin Brown <kevin@sysexperts.com> writes:
> I'm looking at the code now (the 7.2.3 code in particular, but I
> suspect for this purpose the code is likely to be very similar to the
> CVS tip), but it's all completely new to me and the developer
> documentation isn't very revealing of the internals.  The optimizer
> code (I've been looking especially at make_jointree_rel() and
> make_fromexpr_rel()) looks a bit tricky...it'll take me some time to
> completely wrap my brain around it.  Any pointers to revealing
> documentation would be quite helpful!

src/backend/optimizer/README is a good place to start.

I'd recommend working with CVS tip; there is little point in doing any
nontrivial development in the 7.2 branch.  You'd have to port it forward
anyway.

            regards, tom lane

pgsql-performance by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: schema/db design wrt performance
Next
From: Ron Johnson
Date:
Subject: Re: schema/db design wrt performance