mlw <markw(at)mohawksoft(dot)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