function calls optimization

From: Andrzej Barszcz <abusinf(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: function calls optimization
Date: 2019-10-31 14:06:13
Message-ID: CAOUVqAxYeH4mO8v8=i1vKgFSy0SLDb6vAkkdnPWOnr2wYYX42g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ?

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Masahiko Sawada 2019-10-31 14:24:37 Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS)
Previous Message Tom Lane 2019-10-31 13:56:17 Re: The command tag of "ALTER MATERIALIZED VIEW RENAME COLUMN"