Skip site navigation (1) Skip section navigation (2)

Re: [WIP] Caching constant stable expressions per execution

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [WIP] Caching constant stable expressions per execution
Date: 2011-09-11 01:02:41
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
> The patch as given has a bunch of implementation issues, but I think
> it's close enough for crude performance testing, and your numbers do
> show a potential performance benefit.  The question that I think is
> unresolved is whether the set of cases covered is wide enough to be
> useful in practice.  I have no data on that ...

Well, I think its use for timestamp/interval/casting functions alone
covers a pretty substantial set of common user actions.  Frankly, the
case of not re-evaluating now() alone would be a significant real-life

If I understand the limitations correctly, though, what this would do is
cause functions to perform substantially differently if called with
expressions as arguments instead of text constants, no?  Seems like that
would lead to some user confusion.  Although, with stuff like now(), we
already have that.

Josh Berkus
PostgreSQL Experts Inc.

In response to


pgsql-hackers by date

Next:From: Fujii MasaoDate: 2011-09-11 01:45:48
Subject: Re: new createuser option for replication role
Previous:From: Thom BrownDate: 2011-09-10 23:47:14
Subject: Re: patch: Allow \dd to show constraint comments

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group