About method of PostgreSQL's Optimizer

Поиск
Список
Период
Сортировка
От Pryscila B Guttoski
Тема About method of PostgreSQL's Optimizer
Дата
Msg-id cf0868bd05091317412310c490@mail.gmail.com
обсуждение исходный текст
Ответы Re: About method of PostgreSQL's Optimizer  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Список pgsql-hackers
Hello all!<br /><br /> On my master course, I'm studying the PostgreSQL's optimizer.<br /> I don't know if anyone in
thislist have been participated from the PostgreSQL's Optimizer development, but maybe someone can help me on this
question.<br/> PostgreSQL generates all possible plans of executing the query (using an almost exhaustive search), then
givesa cost to each plan and finally the cheapest one is selected for execution.<br /> There are other methods for
queryoptimization, one of them is based on plan transformations (for example, using A-Star algorithm) instead of plan
constructionsused by PostgreSQL. <br /> Does anyone know why this method was choosen? Are there any papers or
researchesabout it?<br /><br /> Thank's a lot,<br /><span class="sg"> Pryscila.<br /></span> 

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

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: Spinlocks, yet again: analysis and proposed patches
Следующее
От: Neil Conway
Дата:
Сообщение: 8.1 system info / admin functions