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

From: Allan Kamau <kamauallan(at)gmail(dot)com>
To: Postgres General Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Does PG cache results of an aggregate function, (and results of non-volatile functions)?
Date: 2009-09-03 07:44:04
Message-ID: ab1ea6540909030044w4786b294v9365337a6a268a81@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nickolay 2009-09-03 08:05:47 easy task: concurrent select-updates
Previous Message gorsa 2009-09-03 07:23:07 maximum count of contiguous years