On Wed, Nov 14, 2012 at 2:30 AM, Aaron Bono <aaron.b...@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.
