Re: Memory use in 8.3 plpgsql with heavy use of xpath() - Mailing list pgsql-general

From Tom Lane
Subject Re: Memory use in 8.3 plpgsql with heavy use of xpath()
Date
Msg-id 3906.1215102825@sss.pgh.pa.us
Whole thread Raw
In response to Re: Memory use in 8.3 plpgsql with heavy use of xpath()  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: Memory use in 8.3 plpgsql with heavy use of xpath()
List pgsql-general
Gregory Stark <stark@enterprisedb.com> writes:
> That's just a special case of what would be expected to happen with memory
> allocation anyways though. Few allocators return memory to the OS anyways.

Well, that does happen on Linux for instance.  Since Matt knew in his
original report that the xpath leak was intra-transaction, I assumed
he must be using a platform where malloc/free can release memory back
to the OS --- else he couldn't have seen that behavior from outside
the backend.

Still, it's entirely possible that some sort of high-water-mark is
involved somewhere, perhaps in malloc's internal data structures.

            regards, tom lane

pgsql-general by date:

Previous
From: Steve Crawford
Date:
Subject: Re: High inserting by syslog
Next
From: aravind chandu
Date:
Subject: xml and postgresql