Nathan Barnett <nbarnett(at)centuries(dot)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