From: | Andy Colson <andy(at)squeakycode(dot)net> |
---|---|
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:13:23 |
Message-ID: | 4D39A293.5000602@squeakycode.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Andy Colson | 2011-01-21 15:16:50 | Re: Privileges of Users |
Previous Message | Andy Colson | 2011-01-21 15:10:35 | Re: Are there any projects interested in object functionality? (+ rule bases) |