Does PG cache results of an aggregate function, (and results of non-volatile functions)?

Поиск
Список
Период
Сортировка
От Allan Kamau
Тема Does PG cache results of an aggregate function, (and results of non-volatile functions)?
Дата
Msg-id ab1ea6540909030044w4786b294v9365337a6a268a81@mail.gmail.com
обсуждение исходный текст
Ответы Re: Does PG cache results of an aggregate function, (and results of non-volatile functions)?  (Bruce Momjian <bruce@momjian.us>)
Re: Does PG cache results of an aggregate function, (and results of non-volatile functions)?  (Merlin Moncure <mmoncure@gmail.com>)
Re: Does PG cache results of an aggregate function, (and results of non-volatile functions)?  (纪晓曦 <sheepjxx@gmail.com>)
Список pgsql-general
Hi,
I do have a query which make use of the results of an aggregate
function (for example bit_or) several times in the output column list
of the SELECT clause, does PostgreSQL simply execute the aggregate
function only once and provide the output to the other calls to the
same aggregate function.
How about the case of non volatile functions? Do they get executed as
many times as they occur in the select clause?

Allan.

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

Предыдущее
От: gorsa
Дата:
Сообщение: maximum count of contiguous years
Следующее
От: Nickolay
Дата:
Сообщение: easy task: concurrent select-updates