From: | Bill Moran <wmoran(at)potentialtech(dot)com> |
---|---|
To: | "Andrus" <kobruleht2(at)hot(dot)ee> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Server stops responding in every week |
Date: | 2011-01-21 15:26:59 |
Message-ID: | 20110121102659.9c0815cd.wmoran@potentialtech.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
In response to "Andrus" <kobruleht2(at)hot(dot)ee>:
> 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 ?
SELECT * FROM pg_locks;
If there are exclusive locks being held by some process that kicks off
once a week, it could block anything else from occurring.
--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/
From | Date | Subject | |
---|---|---|---|
Next Message | Andrus | 2011-01-21 15:43:07 | Re: Server stops responding in every week |
Previous Message | Andy Colson | 2011-01-21 15:23:34 | Re: Server stops responding in every week |