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