function calls optimization - Mailing list pgsql-hackers

From Andrzej Barszcz
Subject function calls optimization
Date
Msg-id CAOUVqAxYeH4mO8v8=i1vKgFSy0SLDb6vAkkdnPWOnr2wYYX42g@mail.gmail.com
Whole thread Raw
Responses Re: function calls optimization  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
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  ? 


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: The command tag of "ALTER MATERIALIZED VIEW RENAME COLUMN"
Next
From: Masahiko Sawada
Date:
Subject: Re: [Proposal] Table-level Transparent Data Encryption (TDE) and KeyManagement Service (KMS)