Re: Optimze usage of immutable functions as relation

Поиск
Список
Период
Сортировка
Искать
От
Andres Freund
Тема
Re: Optimze usage of immutable functions as relation
Дата
Msg-id
20190216014332.ifjqaaew4tfvzpnk@alap3.anarazel.de
Ответ на
Список
Дерево обсуждения
Optimze usage of immutable functions as relation Aleksandr Parfenov <a.parfenov@postgrespro.ru>
Re: Optimze usage of immutable functions as relation Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Optimze usage of immutable functions as relation Aleksandr Parfenov <a.parfenov@postgrespro.ru>
Re: Optimze usage of immutable functions as relation Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Optimze usage of immutable functions as relation Aleksandr Parfenov <a.parfenov@postgrespro.ru>
Re: Optimze usage of immutable functions as relation Heikki Linnakangas <hlinnaka@iki.fi>
Re: Optimze usage of immutable functions as relation Tom Lane <tgl@sss.pgh.pa.us>
Re: Optimze usage of immutable functions as relation Aleksandr Parfenov <a.parfenov@postgrespro.ru>
Re: Optimze usage of immutable functions as relation Anthony Bykov <a.bykov@postgrespro.ru>
Re: Optimze usage of immutable functions as relation Aleksandr Parfenov <asp437@gmail.com>
Re: Optimze usage of immutable functions as relation Antonin Houska <ah@cybertec.at>
Re: Optimze usage of immutable functions as relation Andres Freund <andres@anarazel.de>
Re: Optimze usage of immutable functions as relation Tom Lane <tgl@sss.pgh.pa.us>
Re: Optimze usage of immutable functions as relation Alexander Kuzmenkov <a.kuzmenkov@postgrespro.ru>
Re: Re: Optimze usage of immutable functions as relation David Steele <david@pgmasters.net>
Re: Optimze usage of immutable functions as relation Alexander Kuzmenkov <a.kuzmenkov@postgrespro.ru>
Re: Optimze usage of immutable functions as relation Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: Optimze usage of immutable functions as relation Antonin Houska <ah@cybertec.at>
Re: Optimze usage of immutable functions as relation Tom Lane <tgl@sss.pgh.pa.us>
Re: Optimze usage of immutable functions as relation Alexander Kuzmenkov <a.kuzmenkov@postgrespro.ru>
Re: Optimze usage of immutable functions as relation Thomas Munro <thomas.munro@gmail.com>
Re: Optimze usage of immutable functions as relation Anastasia Lubennikova <a.lubennikova@postgrespro.ru>
Re: Optimze usage of immutable functions as relation Anastasia Lubennikova <a.lubennikova@postgrespro.ru>
Re: Optimze usage of immutable functions as relation Tom Lane <tgl@sss.pgh.pa.us>
Re: Optimze usage of immutable functions as relation Anastasia Lubennikova <a.lubennikova@postgrespro.ru>
Re: Optimze usage of immutable functions as relation Tom Lane <tgl@sss.pgh.pa.us>
Re: Optimze usage of immutable functions as relation rmrodriguez@carto.com
Re: Optimze usage of immutable functions as relation Tom Lane <tgl@sss.pgh.pa.us>
Re: Optimze usage of immutable functions as relation Tom Lane <tgl@sss.pgh.pa.us>
On 2018-11-08 15:08:03 +0100, Antonin Houska wrote:
> Aleksandr Parfenov  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.

Given this I think the appropriate state of the CF entry would have been
waiting-for-author, not needs review. Or alternatively
returned-with-feedback or rejected.  I'm a bit confused as to why the
patch was moved to the next CF twice?

- Andres

В списке pgsql-hackers по дате отправления
От: Michael Paquier
Дата:
Сообщение: Re: Channel binding
От: Tomas Vondra
Дата:
FAQ