On 12/22/2011 12:29 AM, Havasvölgyi Ottó wrote: > Hello, > > Can you find some relation between the memory usage and insert > statements? 9.1.2 has memory problems with inserts (even the simplest > ones) on Linux and Windows too, I could produce it. Using pgbench also > shows it. Some memory is not reclaimed. > I could produce it also with 8.4.9 on Linux, I haven't tried 8.4.10 yet. >
Our problem should not have anything to do with this bug (it was introduced in 9.1.2)
We could not finish a full import of some of our databases with 9.1.2 because all ram+swap was used in a matter of minuttes. We are using 9.1.1 and we haven't seen the 9.1.2 behavior.
regards, - -- Rafael Martinez Guerrero Center for Information Technology University of Oslo, Norway