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

From Matt Magoffin
Subject Re: Memory use in 8.3 plpgsql with heavy use of xpath()
Date
Msg-id 49593.192.168.1.108.1214949465.squirrel@msqr.us
Whole thread Raw
In response to Re: Memory use in 8.3 plpgsql with heavy use of xpath()  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Memory use in 8.3 plpgsql with heavy use of xpath()
List pgsql-general
> Ugh.  Sounds like "small memory leak inside libxml2" --- probably not
> going to be easy to find.  Can you put together a self-contained test
> case?

OK, I'll try to come up with something. Do you have a recommended way of
capturing the amount memory being used by Postgres related to this? I was
thinking I would have a plpgsql function that loops a large number of
times, calling a few xpath() calls, and could take a memory snapshot
before/after the function completes. Is there a call within Postgres I can
make, or should I just rely on OS-level tools for this?

-- m@

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Memory use in 8.3 plpgsql with heavy use of xpath()
Next
From: "Chandra Barnett"
Date:
Subject: Re: Problem with roles and permissions