Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id B73101816035 for ; Thu, 22 Dec 2011 05:00:41 -0400 (AST) Received: from mail-out1.uio.no ([2001:700:100:10::57]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RdeVy-0007xM-LV for pgsql-performance@postgresql.org; Thu, 22 Dec 2011 09:00:40 +0000 Received: from mail-mx2.uio.no ([129.240.10.30]) by mail-out1.uio.no with esmtp (Exim 4.75) (envelope-from ) id 1RdeVl-0005RO-UV; Thu, 22 Dec 2011 10:00:25 +0100 Received: from bbking.uio.no ([129.240.6.205]) by mail-mx2.uio.no with esmtpsa (TLSv1:CAMELLIA256-SHA:256) user rafael (Exim 4.76) (envelope-from ) id 1RdeVl-00008P-FU; Thu, 22 Dec 2011 10:00:25 +0100 Message-ID: <4EF2F1A5.8010502@usit.uio.no> Date: Thu, 22 Dec 2011 10:00:21 +0100 From: Rafael Martinez Organization: University of Oslo User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.24) Gecko/20111104 Red Hat/3.1.16-2.el6_1 Thunderbird/3.1.16 MIME-Version: 1.0 To: =?ISO-8859-1?Q?Havasv=F6lgyi_Ott=F3?= CC: Craig Ringer , pgsql-performance@postgresql.org Subject: Re: Dramatic change in memory usage with version 9.1 References: <4EEF5296.2030101@usit.uio.no> <4EF11EE6.6020203@ringerc.id.au> <4EF21C70.5000200@usit.uio.no> In-Reply-To: X-Enigmail-Version: 1.1.2 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-UiO-Ratelimit-Test: rcpts/h 3 msgs/h 1 sum rcpts/h 5 sum msgs/h 2 total rcpts 3448 max rcpts/h 19 ratelimit 0 X-UiO-Spam-info: not spam, SpamAssassin (score=-10.0, required=5.0, autolearn=disabled, RP_MATCHES_RCVD=-2.023, UIO_MAIL_IS_INTERNAL=-5, UIO_PGP_SIGNED=-3, uiobl=NO, uiouri=NO) X-UiO-Scanned: E5B95A0931C48BBBF7E7E30904D397F8731FB5C6 X-UiO-SPAM-Test: remote_host: 129.240.6.205 spam_score: -99 maxlevel 80 minaction 2 bait 0 mail/h: 1 total 2086 max/h 13 blacklist 0 greylist 0 ratelimit 0 X-Pg-Spam-Score: -4.5 (----) X-Archive-Number: 201112/150 X-Sequence-Number: 45949 -----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-----