Re: Postgresql 9.1.2 - abnormal memory usage

Hi Heikki,

On 12/12/2011 09:29, Heikki Linnakangas wrote:
> On 12.12.2011 08:26, Tom Lane wrote:
>> Andres Freund<andres(at)anarazel(dot)de> writes:
>>> In 3b8161723c645853021b57330dd2ea0484ec6131 Heikki made DatumGetInetP
>>> unpack
>>> toasted values. Unfortunately the btree support functions for the
>>> inet type
>>> didn't free memory which they have to do in contrast to about
>>> everything else.
>>
>>> I fixed a few more functions than strictly necessary but I guess
>>> thats ok.
>>
>> Seems like the correct fix is to revert these functions to the former
>> behavior, ie they should be using the PP macros not the unpacking ones.
>
> Agreed, there's no need to unpack here. Fixed, thanks for the report!

Just to clarify, am I correct assuming that the issue does not affect
tables which have non-indexed inet fields?

Cheers
--
Matteo Beccati

Development & Consulting - http://www.beccati.com/