Re: Removing unneeded self joins

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Removing unneeded self joins
Дата
Msg-id CAM-w4HMS0N9y73AzwTwU_K9=25JMs0cTUoo_8MR_83Gh+Ci7wA@mail.gmail.com
обсуждение исходный текст
Ответ на Removing unneeded self joins  (Alexander Kuzmenkov <a.kuzmenkov@postgrespro.ru>)
Список pgsql-hackers
I don't think the benchmarking that's needed is to check whether
pruning unnecessary joins is helpful. Obviously it's going to be hard
to measure on simple queries and small tables. But the resulting plan
is unambiguously superior and in more complex cases could extra i/o.

The benchmarking people were looking for in the past was testing the
impact of the extra planning work in cases where it doesn't end up
being applied. I'm not sure what the worst case is, perhaps a many-way
self-join where the join clauses are not suitable for pruning?



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

Предыдущее
От: Masahiko Sawada
Дата:
Сообщение: Re: Showing I/O timings spent reading/writing temp buffers in EXPLAIN
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Allow root ownership of client certificate key