Re: Removing unneeded self joins

Поиск
Список
Период
Сортировка
От Andrey Lepikhov
Тема Re: Removing unneeded self joins
Дата
Msg-id 05469e80-454b-41d7-d04f-421f42bbd4a9@postgrespro.ru
обсуждение исходный текст
Ответ на Re: Removing unneeded self joins  (Andrey Lepikhov <a.lepikhov@postgrespro.ru>)
Ответы Re: Removing unneeded self joins  (Alexander Korotkov <aekorotkov@gmail.com>)
Список pgsql-hackers
On 5/7/2023 21:28, Andrey Lepikhov wrote:
> Hi,
> 
> During the significant code revision in v.41 I lost some replacement 
> operations. Here is the fix and extra tests to check this in the future.
> Also, Tom added the JoinDomain structure five months ago, and I added 
> code to replace relids for that place too.
> One more thing, I found out that we didn't replace SJs, defined by 
> baserestrictinfos if no one self-join clause have existed for the join. 
> Now, it is fixed, and the test has been added.
> To understand changes readily, see the delta file in the attachment.
Here is new patch in attachment. Rebased on current master and some 
minor gaffes are fixed.

-- 
regards,
Andrey Lepikhov
Postgres Professional

Вложения

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

Предыдущее
От: Suraj Kharage
Дата:
Сообщение: Server crash on RHEL 9/s390x platform against PG16
Следующее
От: "Hayato Kuroda (Fujitsu)"
Дата:
Сообщение: RE: [PoC] pg_upgrade: allow to upgrade publisher node