Re: Memory Usage

Nathan Barnett <nbarnett@centuries.com> writes:
> UPDATE pages SET createdtime = NOW();

> Is there a reason why this would take up all of the memory??

The now() function invocation leaks memory ... only a dozen or so bytes
per invocation, but that adds up over millions of rows :-(.  In 7.0.*
the memory isn't recovered until end of statement.  7.1 fixes this by
recovering temporary memory after each tuple.

You'll see the same behavior for functions and operators on any
pass-by-reference datatype, not just timestamp.

            regards, tom lane