Re: Removing unneeded self joins

Поиск
Список
Период
Сортировка
От Andrey Lepikhov
Тема Re: Removing unneeded self joins
Дата
Msg-id a141d07f-d686-f42e-c4e5-f22dd33b40bd@postgrespro.ru
обсуждение исходный текст
Ответ на Re: Removing unneeded self joins  (Hywel Carver <hywel@skillerwhale.com>)
Ответы Re: Removing unneeded self joins
Re: Removing unneeded self joins
Список pgsql-hackers
On 6/7/21 13:49, Hywel Carver wrote:
> On Mon, Jul 5, 2021 at 2:20 PM Andrey Lepikhov 
> <a.lepikhov@postgrespro.ru <mailto:a.lepikhov@postgrespro.ru>> wrote:
> Looking through the email chain, a previous version of this patch added 
> ~0.6% to planning time in the worst case tested - does that meet the 
> "essentially free" requirement?
I think these tests weren't full coverage of possible use cases. It will 
depend on a number of relations in the query. For the JOIN of 
partitioned tables, for example, the overhead could grow. But in the 
context of overall planning time this overhead will be small till the 
large number of relations.
Also, we made this feature optional to solve possible problems.
Rebased on 768ea9bcf9

-- 
regards,
Andrey Lepikhov
Postgres Professional

Вложения

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

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: Re: What are exactly bootstrap processes, auxiliary processes, standalone backends, normal backends(user sessions)?
Следующее
От: Ronan Dunklau
Дата:
Сообщение: Re: [PATCH] Use optimized single-datum tuplesort in ExecSort