Re: Proposed Query Planner TODO items

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Proposed Query Planner TODO items
Дата
Msg-id 22262.1076353717@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Proposed Query Planner TODO items  (markw@osdl.org)
Ответы Re: Proposed Query Planner TODO items  (markw@osdl.org)
Список pgsql-hackers
Josh Berkus <josh@agliodbs.com> writes:
> If #19 is missing it's because Oleg & I could not get it to complete.  That 
> was also the query which we are most interested in testing.

Q19 doesn't seem to be particularly slow in either the 7.4 or 7.5 tests
--- there are many others with longer runtimes.  I speculate that what
is actually being run here is a modified Q19 query with the merge join
condition pulled out by hand.  The CVS-tip planner should be able to do
that for itself, though, and obtain essentially this same performance
with the per-spec query.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: 7.4.1 release status - Turkish Locale
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Question on pg_dump