From: Rafael Martinez <r.m.guerrero@usit.uio.no>
To: Havasvölgyi Ottó <havasvolgyi.otto@gmail.com>
Cc: Craig Ringer <ringerc@ringerc.id.au>
Cc: pgsql-performance@postgresql.org
Subject: Re: Dramatic change in memory usage with version 9.1
Date: Thu, 22 Dec 2011 10:00:21 +0100
Message-ID: <4EF2F1A5.8010502@usit.uio.no> (raw)
In-Reply-To: <CAOryeA1sQU6azFtKjWMPZ7EJHK3vF4O_G0J46wvMqRX5Pu-6Gw@mail.gmail.com>
References: <4EEF5296.2030101@usit.uio.no>
<4EF11EE6.6020203@ringerc.id.au>
<4EF21C70.5000200@usit.uio.no>
<CAOryeA1sQU6azFtKjWMPZ7EJHK3vF4O_G0J46wvMqRX5Pu-6Gw@mail.gmail.com>
-----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-----
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: r.m.guerrero@usit.uio.no, havasvolgyi.otto@gmail.com, ringerc@ringerc.id.au
Subject: Re: Dramatic change in memory usage with version 9.1
In-Reply-To: <4EF2F1A5.8010502@usit.uio.no>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox