Re: [GENERAL] High memory usage with savepoints & encoding differences

2009-04-17 Thread Dylan Adams
Tom Lane writes: > I think this example is pretty artificial. The fundamental reason > memory is increasing is that each subtransaction can require > some state > storage. In the example the per-subtransaction CurTransactionContexts > are not getting used for anything except encoding conversion

Re: [GENERAL] High memory usage with savepoints & encoding differences

2009-04-17 Thread Tom Lane
"Dylan Adams" writes: > I'm running into a situation where postmaster is consuming significantly > more memory than I would expect. This only seems to happen when I > combine savepoints with differences between client and database > encoding. I originally discovered this while running some Java co

[GENERAL] High memory usage with savepoints & encoding differences

2009-04-17 Thread Dylan Adams
I'm running into a situation where postmaster is consuming significantly more memory than I would expect. This only seems to happen when I combine savepoints with differences between client and database encoding. I originally discovered this while running some Java code which uses JDBC (the postgre