Re: Dramatic change in memory usage with version 9.1

From: Havasvölgyi Ottó <havasvolgyi(dot)otto(at)gmail(dot)com>
To: Rafael Martinez <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no>
Cc: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Dramatic change in memory usage with version 9.1
Date: 2011-12-22 09:58:57
Message-ID: CAOryeA1jxJAOh90r7g9mBkqA_EDkKD2aLxXvw=GvaveahfzJnw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Yes, perhaps it is related to it, and the cause is the same. But they
mention here a special type inet.

Best regards,
Otto

2011/12/22 Rafael Martinez <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no>

> -----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-----
>

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message tuanhoanganh 2011-12-23 03:36:24 Postgresql 9.0.6 Raid 5 or not please help.
Previous Message Rafael Martinez 2011-12-22 09:00:21 Re: Dramatic change in memory usage with version 9.1