Re: 7.3.1 New install, large queries are slow

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 7.3.1 New install, large queries are slow
Дата
Msg-id 15059.1042731982@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: 7.3.1 New install, large queries are slow  (Kevin Brown <kevin@sysexperts.com>)
Список 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 по дате отправления:

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: schema/db design wrt performance
Следующее
От: Ron Johnson
Дата:
Сообщение: Re: schema/db design wrt performance