On Friday 21 January 2011 7:13:23 am Andy Colson wrote: > On 1/21/2011 7:16 AM, Andrus wrote: > > PostgreSQL 9.0.1, compiled by Visual C++ build 1500, 64-bit > > is installed in Windows 2008 server and servers 23 users in LAN 10 hours > > per work day. > > > > Approx once per week server stops responding: Users are waiting 4 > > minutes for query to complete but nothing happens. > > > > If postgres service is re-started in Windows Control panel, it continues > > working for a week and same issue appears again. > > Server and windows event log does not contian any information about > > issue. > > > > > > How to fix of diagnose it ? > > Should I move to 32 Postgres 9.0 server or other idea ? > > > > Andrus. > > Does PG start swapping to disk? > Does ram using increase over the week? > Have you looked at pg_stat_activity and pg_locks? > Do you see "Idle in transaction" (probably in task manager)? > > -Andy To add to this. Is there a backup being done? Maybe not pg_dump but some Windows backup program? -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
