Re: [HACKERS] palloc? (re: What's with update?)

[Tom Lane]

mlw <[EMAIL PROTECTED]> writes:
> I think I know what the problem is:
> I have a couple indexes created with a "lower" function to index on
> lowercase.

Ah.  You're correct, functional indexes leak memory in existing PG
releases.  The memory is reclaimed at end of statement, which is not
soon enough if you insert/update a large number of rows.

I think this is fixed in 7.1 though, if you want to try it...

                        regards, tom lane