Re: Postgre Eating Up Too Much RAM

Поиск
Список
Период
Сортировка
От Fernando Hevia
Тема Re: Postgre Eating Up Too Much RAM
Дата
Msg-id CAGYT1XTieQp5QNCrrdwnQWdaDez7txw+i16GiSkhJTz531qqSQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Postgre Eating Up Too Much RAM  (Aaron Bono <aaron.bono@aranya.com>)
Ответы Re: Postgre Eating Up Too Much RAM  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-admin



On Wed, Nov 14, 2012 at 2:30 AM, Aaron Bono <aaron.bono@aranya.com> wrote:
On our old server, our hosting company said the server was running out of RAM and then became unresponsive.  I haven't checked about the new server yet.

Unresponsive how? Can you ssh to it? Can you log to Postgres?
For how long does it happen? Till you reboot?
If it is a server crash then that is not a normal behavior and you should check your hardware. An exhaustive memory test is recommended.
 
Is there any kind of diagnostics you can think of that would help get to the root of the problem - something I could put in a cron job or a monitor app I could run on the server that would at least tell us what is going on if / when it happens again?


Increase logging on PostgreSQL. Especially log checkpoints and locks.
While experiencing the problem and if you are able to log to the server, a vmstat 1 10 will tell you what is going on with your I/O system in a 10 second span. 

Regards,
Fernando.

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

Предыдущее
От: Frank Cavaliero
Дата:
Сообщение: Failed Login Attempts parameter
Следующее
От: Shams Khan
Дата:
Сообщение: Query Stuck in running server