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 <joc...@pgsql-bugs.erwied.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: joc...@erwied.eu +49-208-38800-18, FAX: > -19 > Sauerbruchstr. 17 | work: j...@mbs-software.de +49-2151-7294-24, FAX: > -50 > D-45470 Muelheim | mobile: jochen.erw...@vodafone.de > +49-173-5404164 > > > -- > Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-bugs >
