| From: | Rafael Martinez <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no> |
|---|---|
| To: | Havasvölgyi Ottó <havasvolgyi(dot)otto(at)gmail(dot)com> |
| 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:00:21 |
| Message-ID: | 4EF2F1A5.8010502@usit.uio.no |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
-----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 | Havasvölgyi Ottó | 2011-12-22 09:58:57 | Re: Dramatic change in memory usage with version 9.1 |
| Previous Message | Jeff Janes | 2011-12-22 08:04:30 | Re: Guidance Requested - Bulk Inserting + Queries |