2011/7/13 Andrus <kobruleht2(at)hot(dot)ee>:
> Sometimes per week server stops randomly responding for approx 5 minutes.
> User should wait for 5 minutes before server responds.
> Other users can work normally at same time.
Sounds very much like a locking issue. Are you doing something like
storing a frequently updated system-wide setting in a table with a
single row?
http://wiki.postgresql.org/wiki/Lock_Monitoring
When the problem happens again, report back what the top query you see
on that wiki page shows.
--
Peter Geoghegan http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training and Services