-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 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. > [...] Hello Are you thinking about this bug?: http://archives.postgresql.org/pgsql-bugs/2011-12/msg00068.php 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 PGP Public Key: http://folk.uio.no/rafael/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.14 (GNU/Linux) iEYEARECAAYFAk7y8aUACgkQBhuKQurGihTD8gCgk0Frrd/mEjQrIgG9K0dzhNxN HzcAnRiQKWBgwZaNSmY+zrGjYSJFva9o =zcv3 -----END PGP SIGNATURE----- -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance