| From: | Andy Colson <andy(at)squeakycode(dot)net> |
|---|---|
| To: | adrian(dot)klaver(at)gmail(dot)com |
| Cc: | pgsql-general(at)postgresql(dot)org, Andrus <kobruleht2(at)hot(dot)ee> |
| Subject: | Re: Server stops responding in every week |
| Date: | 2011-01-21 15:23:34 |
| Message-ID: | 4D39A4F6.1010209@squeakycode.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 1/21/2011 9:21 AM, Adrian Klaver wrote:
> 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?
>
Yes yes... or antivirus full scan kicking off?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bill Moran | 2011-01-21 15:26:59 | Re: Server stops responding in every week |
| Previous Message | Adrian Klaver | 2011-01-21 15:21:13 | Re: Server stops responding in every week |