Re: [PATCH] Erase the distinctClause if the result is unique by definition

Поиск
Список
Период
Сортировка
От Andy Fan
Тема Re: [PATCH] Erase the distinctClause if the result is unique by definition
Дата
Msg-id CAKU4AWqi8_N+13+msrDOK1HZhLppSY0RN9gxESYFKzjKmX4E1w@mail.gmail.com
обсуждение исходный текст
Ответ на [PATCH] Erase the distinctClause if the result is unique by definition  (Andy Fan <zhihui.fan1213@gmail.com>)
Ответы Re: [PATCH] Erase the distinctClause if the result is unique by definition  (Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>)
Список pgsql-hackers
Дерево обсуждения
update the patch with considering the semi/anti join. 

Can anyone help to review this patch?  

Thanks


On Fri, Jan 31, 2020 at 8:39 PM Andy Fan <zhihui.fan1213@gmail.com> wrote:
Hi:

I wrote a patch to erase the distinctClause if the result is unique by 
definition,  I find this because a user switch this code from oracle 
to PG and find the performance is bad due to this,  so I adapt pg for
this as well. 

This patch doesn't work for a well-written SQL,  but some drawback 
of a SQL may be not very obvious,  since the cost of checking is pretty
low as well,  so I think it would be ok to add.. 

Please see the patch for details.   

Thank you. 
Вложения

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: In PG12, query with float calculations is slower than PG11
Следующее
От: Kasahara Tatsuhito
Дата:
Сообщение: Re: Tid scan increments value of pg_stat_all_tables.seq_scan. (butnot seq_tup_read)