| 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: | Whole Thread | Raw Message | 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-----
>
| 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 |