Re: Hints (Was: Index Tuning Features)

Поиск
Список
Период
Сортировка
От Arturo Perez
Тема Re: Hints (Was: Index Tuning Features)
Дата
Msg-id aperez-51E545.08010913102006@news.hub.org
обсуждение исходный текст
Ответ на Re: Index Tuning Features  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
In article <20061012112647.GD28443@phlogiston.dyndns.org>,ajs@crankycanuck.ca (Andrew Sullivan) wrote:

> On Thu, Oct 12, 2006 at 08:34:45AM +0200, Florian Weimer wrote:
> > 
> > Some statistics are very hard to gather from a sample, e.g. the number
> > of distinct values in a column.
> 

> I like the suggestion, though, that there be ways to codify known
> relationships in the system in such a way that the optimizer can
> learn to use that information.  

Since there is already a genetic-algorithm based optimizer, is there any 
way to use that to gather information to improve statistics?

For example, put the GA optimizer into a mode where it tries some of the 
plans it comes up with and collects data on how they perform?

-arturo


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

Предыдущее
От: "Zeugswetter Andreas ADI SD"
Дата:
Сообщение: Re: Hints WAS: Index Tuning Features
Следующее
От: NikhilS
Дата:
Сообщение: Additional stats for Relations