Re: Removing unneeded self joins

Поиск
Список
Период
Сортировка
От Andrey Lepikhov
Тема Re: Removing unneeded self joins
Дата
Msg-id c0f41cba-659d-c6e1-7fb4-85e703dc2395@postgrespro.ru
обсуждение исходный текст
Ответ на Re: Removing unneeded self joins  (Greg Stark <stark@mit.edu>)
Ответы Re: Removing unneeded self joins  (Ronan Dunklau <ronan.dunklau@aiven.io>)
Список pgsql-hackers
New version of the feature.
Here a minor bug with RowMarks is fixed. A degenerated case is fixed, 
when uniqueness of an inner deduced not from join quals, but from a 
baserestrictinfo clauses 'x=const', where x - unique field.
Code, dedicated to solve second issue is controversial, so i attached 
delta.txt for quick observation.
Maybe we should return to previous version of code, when we didn't split 
restriction list into join quals and base quals?

-- 
Regards
Andrey Lepikhov
Postgres Professional
Вложения

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

Предыдущее
От: Amul Sul
Дата:
Сообщение: Re: Correct comment in ProcedureCreate() for pgstat_create_function() call.
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: Data is copied twice when specifying both child and parent table in publication