ITAGAKI Takahiro wrote:
Tom Lane [EMAIL PROTECTED] wrote:
Marshall, Steve [EMAIL PROTECTED] writes:
I have developed a small patch to optimizer/util/plancat.c that
eliminates one of hte caveats associated with constraint exclusions,
namely the inability to avoid searching tables
I have developed a small patch to optimizer/util/plancat.c that
eliminates one of hte caveats associated with constraint exclusions,
namely the inability to avoid searching tables based on the results of
stable functions. The new code expands non-volatile functions into
constant values so
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 13, 2006 2:08 PM
To: Marshall, Steve
Cc: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] - Proposal for repreparing prepared statements
Stephen Marshall [EMAIL PROTECTED] writes:
The following is a proposal for work I'd like to do to force
Marshall, Steve [EMAIL PROTECTED] writes:
1. Is the invalidation of stored plans going to be part of 8.2? If
not, any idea when it would be available? I'd be willing to work on
this, if it would help.
No, it did not get done; feel free to work on it for 8.3.
[steve's reply]:
Could you
But forcing a reload of pltcl.so is nothing but a kluge --- it leaks
memory like there's no tomorrow, and it's only an accident that it fails
to crash. I don't want to design a further kluge on top of it.
Are you saying that pltcl.so leaks memory in general, or that forcing a
reload of the