Re: palloc? (re: What's with update?) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: palloc? (re: What's with update?)
Date
Msg-id 4136.979842495@sss.pgh.pa.us
Whole thread Raw
In response to palloc? (re: What's with update?)  (mlw <markw@mohawksoft.com>)
List pgsql-hackers
mlw <markw@mohawksoft.com> 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


pgsql-hackers by date:

Previous
From: "Mikheev, Vadim"
Date:
Subject: RE: compiling 7.1-beta1
Next
From: Aditya Damle
Date:
Subject: A bug with unique indicies