Postgres 9.0 locking up, 100% CPU
- by Jake
We are having a problem where our Postgres 9.0 server occasionally locks up and kills our webapp. Restarting Postgres fixes the problem.
Here's what I've been able to observe:
First, usage of one CPU jumps to 100% for a few minutes
Disk operations drop to ~0 during this time
Database operations drop to 0 (blocks and tuples per sec)
Logs show…