Re: Memory use in 8.3 plpgsql with heavy use of xpath()

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Gregory Stark <stark(at)enterprisedb(dot)com>
Cc: "Matt Magoffin" <postgresql(dot)org(at)msqr(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: Memory use in 8.3 plpgsql with heavy use of xpath()
Date: 2008-07-03 16:33:45
Message-ID: 3906.1215102825@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Gregory Stark <stark(at)enterprisedb(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message aravind chandu 2008-07-03 19:14:24 xml and postgresql
Previous Message Steve Crawford 2008-07-03 16:32:53 Re: High inserting by syslog