Re: An Idea for planner hints

Поиск
Список
Период
Сортировка
От Joshua Reich
Тема Re: An Idea for planner hints
Дата
Msg-id 44DA3881.4020201@root.net
обсуждение исходный текст
Ответ на Re: An Idea for planner hints  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: An Idea for planner hints
Список pgsql-hackers
> (Not sure how we'd implement that, seeing that ANALYZE currently works
> on one table at a time, but it's probably doable --- and it'd fix the
> fundamental problem for correlation statistics, which is how not to try
> to collect stats about an exponential number of combinations ...)


An exponential number of combinations? Is it possible to use FK 
relationships to determine what tables & columns are likely to be used 
in future joins.

Josh



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

Предыдущее
От: Mark Dilger
Дата:
Сообщение: Re: An Idea for planner hints
Следующее
От: "Dave Page"
Дата:
Сообщение: Re: 8.2 features status