Re: An Idea for planner hints

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: An Idea for planner hints
Дата
Msg-id 200608171055.28899.peter_e@gmx.net
обсуждение исходный текст
Ответ на Re: An Idea for planner hints  (Gregory Stark <gsstark@mit.edu>)
Ответы Re: An Idea for planner hints  (Greg Stark <gsstark@mit.edu>)
Список pgsql-hackers
Gregory Stark wrote:
> I'm not sure it's worth throwing out the more user-friendly interface
> we have now but I think it's clear that a table is the obvious
> "machine-readable format" if you're already sitting in an SQL
> database... :)

Then again, a table might not be the optimal format for an inherently 
hierarchical structure.

But we're getting ahead of ourselves.  There are three parts to this:

1. determine what statistics to gather
2. gather those statistics
3. use those statistics

#1 can really be handled manually in the beginning, and you'd still have 
an excessively useful system if #2 and #3 are available.  Once that is 
done, we can gain experience with the system and maybe find a way to 
automate #1, but it really does not need to be the first step.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


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

Предыдущее
От: Markus Schiltknecht
Дата:
Сообщение: news server does not respond
Следующее
От: Stefan Kaltenbrunner
Дата:
Сообщение: Re: Going for "all green" buildfarm results