Re: Generating code for query jumbling through gen_node_support.pl

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Generating code for query jumbling through gen_node_support.pl
Дата
Msg-id Y9i3+PdW+REPD2oE@paquier.xyz
обсуждение исходный текст
Ответ на Re: Generating code for query jumbling through gen_node_support.pl  (Peter Eisentraut <peter.eisentraut@enterprisedb.com>)
Ответы Re: Generating code for query jumbling through gen_node_support.pl  (Michael Paquier <michael@paquier.xyz>)
Re: Generating code for query jumbling through gen_node_support.pl  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Mon, Jan 30, 2023 at 11:48:45AM +0100, Peter Eisentraut wrote:
> I'm going to set this thread as "Ready for Committer".  Either wait a bit
> for more feedback on this topic, or just go ahead with either solution.  We
> can leave it as a semi-open item for reconsideration later.

All the measurements I have done for the last couple of days point me
in the direction that there is no need for an extra node based on the
averaged computation times (did a few more today with some long CREATE
FUNCTION, VIEW or event trigger queries, for example).  Agreed to add
the extra option as something to consider at some point during beta,
as long as it is fresh.  I am not convinced that it will be necessary
but let's see how it goes.

While reviewing all the nodes, I have noticed two mistakes for a few
things marked as query_jumble_ignore but they should not:
- orderClause in WindowClause
- aliascolnames in CommonTableExpr
The rest was fine.

varnullingrels has been added very recently, and there was in
queryjumblefuncs.c a comment explaining why it should be ignored.
This has been moved to nodes.h, like the others.

With all that in mind, I have spent my day polishing that and doing a
close lookup, and the patch has been applied.  Thanks a lot!
--
Michael

Вложения

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

Предыдущее
От: Sam Saffron
Дата:
Сообщение: Contractions in full text search result in very surprising stemming
Следующее
От: Fujii Masao
Дата:
Сообщение: Re: Refactoring postgres_fdw/connection.c