Re: Optimze usage of immutable functions as relation

Поиск
Список
Период
Сортировка
От Antonin Houska
Тема Re: Optimze usage of immutable functions as relation
Дата
Msg-id 11120.1541686083@localhost
обсуждение исходный текст
Ответ на Re: Optimze usage of immutable functions as relation  (Aleksandr Parfenov <asp437@gmail.com>)
Ответы Re: Optimze usage of immutable functions as relation  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
Aleksandr Parfenov <asp437@gmail.com> wrote:

> I fixed a typo and some comments. Please find new version attached.

I've checked this verstion too.

* is_simple_stable_function()

instead of fetching HeapTuple from the syscache manually, you might want to
consider using functions from lsyscache.c (get_func_rettype, get_func_retset,
etc.), or adding a function that returns (subset of) the fields you need in a
single call.

* pull_up_simple_function():

As you assume that ret->functions is a single-item list

    Assert(list_length(rte->functions) == 1);

the following iteration is not necessary:

    foreach(lc, functions_list)

Also, there seems to be a lot of copy & paste from pull_up_simple_values(), so
some refactoring would make sense.


--
Antonin Houska
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26, A-2700 Wiener Neustadt
Web: https://www.cybertec-postgresql.com


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

Предыдущее
От: Antonin Houska
Дата:
Сообщение: Re: Optimze usage of immutable functions as relation
Следующее
От: Markus Winand
Дата:
Сообщение: Re: PostgreSQL vs SQL/XML Standards