Re: [HACKERS] Allow use of immutable functions operating on constants with constraint exclusion

2007-05-08 Thread Marshall, Steve
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

[HACKERS] Allow use of stable functions with constraint exclusion

2007-04-30 Thread Marshall, Steve
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

Re: [HACKERS] - Proposal for repreparing prepared statements

2006-09-13 Thread Marshall, Steve
[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

Re: [HACKERS] - Proposal for repreparing prepared statements

2006-09-13 Thread Marshall, Steve
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

Re: [HACKERS] - Proposal for repreparing prepared statements

2006-09-13 Thread Marshall, Steve
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