Re: Postgresql 9.1.2 - abnormal memory usage

Hi,

A simple query "insert into mytable default values" on a single
serial-column table also leaks. It can also produced by pgbench. On
Windows and Linux too.

Best regards,
Otto

2011/12/12 Jochen Erwied <jochen(at)pgsql-bugs(dot)erwied(dot)eu>

> Monday, December 12, 2011, 12:33:03 PM you wrote:
>
> > On 12.12.2011 13:16, Matteo Beccati wrote:
>
> >> Just to clarify, am I correct assuming that the issue does not affect
> >> tables which have non-indexed inet fields?
>
> > Hmm, I think it might also affect queries that do large merge joins on
> > inet fields. Not sure about that. In any case, it's a memory leak that
> > gets cleared at the end of statement, so it can only become a problem
> > when dealing with large data sets.
>
> The second test case I originally sent uses inet-functions in a complicated
> query, and it also shows the described behaviour.
>
> So the problem is not limited to indexes, but also will appear in queries!
>
> --
> Jochen Erwied | home: jochen(at)erwied(dot)eu +49-208-38800-18, FAX:
> -19
> Sauerbruchstr. 17 | work: joe(at)mbs-software(dot)de +49-2151-7294-24, FAX:
> -50
> D-45470 Muelheim | mobile: jochen(dot)erwied(at)vodafone(dot)de
> +49-173-5404164
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>