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 inabil

[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 the

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 plt

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

Re: [HACKERS] - Proposal for repreparing prepared statements

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