Why could GEQO produce plans with lower costs than thestandard_join_search?

Поиск
Список
Период
Сортировка
От Donald Dong
Тема Why could GEQO produce plans with lower costs than thestandard_join_search?
Дата
Msg-id 5A76B3F6-200F-4721-94E9-9C377F582568@csumb.edu
обсуждение исходный текст
Ответы Re: Why could GEQO produce plans with lower costs than the standard_join_search?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi,

I was expecting the plans generated by standard_join_search to have lower costs
than the plans from GEQO. But after the results I have from a join order
benchmark show that GEQO produces plans with lower costs most of the time!

I wonder what is causing this observation? From my understanding,
standard_join_search is doing a complete search. So I'm not sure how the GEQO
managed to do better than that.

Thank you,
Donald Dong


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

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: New EXPLAIN option: ALL
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Heap lock levels for REINDEX INDEX CONCURRENTLY not quite right?