Re: [PATCH] Caching for stable expressions with constant arguments v3 - Mailing list pgsql-hackers

From Marti Raudsepp
Subject Re: [PATCH] Caching for stable expressions with constant arguments v3
Date
Msg-id CABRT9RD=2zDnLzQEYU7_SsgR7nJ5ZOazDm6uAg4_V1FxFPxPNA@mail.gmail.com
Whole thread Raw
In response to Re: [PATCH] Caching for stable expressions with constant arguments v3  (Jaime Casanova <jaime@2ndquadrant.com>)
Responses Re: [HACKERS] [PATCH] Caching for stable expressions with constant arguments v3  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Fri, Dec 16, 2011 at 21:32, Jaime Casanova <jaime@2ndquadrant.com> wrote:
> Actually i tried some benchmarks with the original version of the
> patch and saw some regression with normal pgbench runs, but it wasn't
> much... so i was trying to found out some queries that show benefit
> now that we have it, that will be a lot more easier

Ah, one more trick for testing this patch: if you build with
-DDEBUG_CACHEEXPR=1 then EXPLAIN VERBOSE displays cached
subexpressions between a CACHE[...] marker.

Regards,
Marti


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Storing hot members of PGPROC out of the band
Next
From: Pavel Stehule
Date:
Subject: Re: review: CHECK FUNCTION statement