Re: Postgresql 9.1.2 - abnormal memory usage

Hi,<br /><br />A simple query "insert into mytable default values" on a single serial-column table also leaks. It can
alsoproduced by pgbench.  On Windows and Linux too.<br /><br />Best regards,<br />Otto<br /><br /><br /><div
class="gmail_quote">2011/12/12 Jochen Erwied <span dir="ltr"><<a
href="mailto:jochen@pgsql-bugs.erwied.eu">jochen@pgsql-bugs.erwied.eu</a>></span><br/><blockquote
class="gmail_quote"style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div
class="im">Monday,December 12, 2011, 12:33:03 PM you wrote:<br /><br /> > On 12.12.2011 13:16, Matteo Beccati
wrote:<br/><br /></div><div class="im">>> Just to clarify, am I correct assuming that the issue does not
affect<br/> >> tables which have non-indexed inet fields?<br /><br /> > Hmm, I think it might also affect
queriesthat do large merge joins on<br /> > inet fields. Not sure about that. In any case, it's a memory leak
that<br/> > gets cleared at the end of statement, so it can only become a problem<br /> > when dealing with large
datasets.<br /><br /></div>The second test case I originally sent uses inet-functions in a complicated<br /> query, and
italso shows the described behaviour.<br /><br /> So the problem is not limited to indexes, but also will appear in
queries!<br/><div class="im HOEnZb"><br /> --<br /> Jochen Erwied     |   home: <a
href="mailto:jochen@erwied.eu">jochen@erwied.eu</a>    <a href="tel:%2B49-208-38800-18"
value="+492083880018">+49-208-38800-18</a>,FAX: -19<br /> Sauerbruchstr. 17 |   work: <a
href="mailto:joe@mbs-software.de">joe@mbs-software.de</a> <a href="tel:%2B49-2151-7294-24"
value="+492151729424">+49-2151-7294-24</a>,FAX: -50<br /> D-45470 Muelheim  | mobile: <a
href="mailto:jochen.erwied@vodafone.de">jochen.erwied@vodafone.de</a>      <a href="tel:%2B49-173-5404164"
value="+491735404164">+49-173-5404164</a><br/><br /><br /></div><div class="HOEnZb"><div class="h5">--<br /> Sent via
pgsql-bugsmailing list (<a href="mailto:pgsql-bugs@postgresql.org">pgsql-bugs@postgresql.org</a>)<br /> To make changes
toyour subscription:<br /><a href="http://www.postgresql.org/mailpref/pgsql-bugs"
target="_blank">http://www.postgresql.org/mailpref/pgsql-bugs</a><br/></div></div></blockquote></div><br />