Re: Dramatic change in memory usage with version 9.1

Поиск
Список
Период
Сортировка
От Rafael Martinez
Тема Re: Dramatic change in memory usage with version 9.1
Дата
Msg-id 4EF2F1A5.8010502@usit.uio.no
обсуждение исходный текст
Ответ на Re: Dramatic change in memory usage with version 9.1  (Havasvölgyi Ottó <havasvolgyi.otto@gmail.com>)
Ответы Re: Dramatic change in memory usage with version 9.1  (Havasvölgyi Ottó <havasvolgyi.otto@gmail.com>)
Список 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-----

В списке pgsql-performance по дате отправления:

Предыдущее
От: nabble.30.miller_2555@spamgourmet.com
Дата:
Сообщение: Re: OOM-killer issue with a specific query SOLVED
Следующее
От: Havasvölgyi Ottó
Дата:
Сообщение: Re: Dramatic change in memory usage with version 9.1