Re: Memory usage after upgrade to 9.2.4

Поиск
Список
Период
Сортировка
От Daniel Cristian Cruz
Тема Re: Memory usage after upgrade to 9.2.4
Дата
Msg-id CACffM9E-yuhzHadhcAuT_pdJW5LTG+XierYZt44TtF9zRLGcdg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Memory usage after upgrade to 9.2.4  (Adrian Klaver <adrian.klaver@gmail.com>)
Ответы Re: Memory usage after upgrade to 9.2.4
Список pgsql-general



2013/4/20 Adrian Klaver <adrian.klaver@gmail.com>
On 04/20/2013 04:08 PM, Daniel Cristian Cruz wrote:
I think I didn't make it clear: the session memory usage is growing up
too fast, until all server memory got used and swap occurs.

Never saw something like that. The version is under a test enviroment
for a long time...

Thanks if someone could help me.

Before any one can help I would think more information is needed;

1) Is it on the same machine/OS as the old version?

Yes same machine, CentOS 5.5, just upgraded PostgreSQL only

2) What are the hardware specs for the machine?

CISCO Blade, 96GB RAM, 24 cores 

3) Is it still in test mode or in production?

production.... sadly 

4) You seem to imply that in test mode everything worked alright, is that the case?

Yes, got two servers, never got the same issue 

5) In either case, test/production, what is being done in the session(s)?

Some complex queries. Some very complex queries... 

6) Is there anything in the Postgres logs that might shed light?

Unfortunelly, not at all. Just the same of previous version, some (more) queries taking longer than 10 seconds.

Old config allowed to use 256MB on work_mem. I reduced to 24MB on new version, but it still grew up strongly and fast.

Not a clue on why this is happening.





--
Daniel Cristian Cruz
クルズ クリスチアン ダニエル


--
Adrian Klaver
adrian.klaver@gmail.com



--
Daniel Cristian Cruz
クルズ クリスチアン ダニエル

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Memory usage after upgrade to 9.2.4
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Memory usage after upgrade to 9.2.4