Re: function calls optimization - Mailing list pgsql-hackers

From Andres Freund
Subject Re: function calls optimization
Date
Msg-id 067303FD-BA50-4036-A097-2E179D190FFD@anarazel.de
Whole thread Raw
In response to function calls optimization  (Andrzej Barszcz <abusinf@gmail.com>)
Responses Re: function calls optimization  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hi,

On October 31, 2019 7:06:13 AM PDT, Andrzej Barszcz <abusinf@gmail.com> wrote:
>Hi
>
>I almost finished patch optimizing non volatile function calls.
>
>select f(t.n) from t where f(t.n) > 10 and f(t.n) < 100;  needs 3 calls
>of
>f() for each tuple,
>after applying patch only 1.
>
>Any pros and cons  ?

Depends on the actual way of implementing this proposal. Think we need more details than what you idea here.

Andres
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.



pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: [Proposal] Table-level Transparent Data Encryption (TDE) and KeyManagement Service (KMS)
Next
From: Tom Lane
Date:
Subject: Re: function calls optimization