2011/7/13 Andrus <kobruleht2@xxxxxx>: > 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
