From: | "Andrus Moor" <kobruleht2(at)hot(dot)ee> |
---|---|
To: | "Andy Colson" <andy(at)squeakycode(dot)net> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Server stops responding in every week |
Date: | 2011-01-22 19:40:55 |
Message-ID: | DB6D5351FF1F4141B6D3DEFBE0782752@server |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Andy,
> Then answer these questions:
>
> Does ram using increase over the week?
Server was re-started yesterday and there was little use after restart.
server is idle. Task Manager shows now
PF Usage 1.22 GB
Physical Memory (K)
Total 4191872
Avail 348xxxx (last 4 vary)
System cache 35676xx (last 2 vary)
How to check for memory increase over week ?
> Do you see "Idle in transaction" (probably in task manager)?
Task Manager shows only image name.
Where I should see this ?
> Show us:
> select * from pg_stat_activity;
I ran it from pgadmin. It shows now :
11874;"postgres";212;10;"postgres";"";"127.0.0.1";1183;"2011-01-22
21:24:51.343+02";"";"2011-01-22 21:24:51.5+02";f;"<IDLE>"
45923;"mydb";3080;10;"postgres";"";"127.0.0.1";1184;"2011-01-22
21:24:55.25+02";"";"2011-01-22 21:24:55.281+02";f;"<IDLE>"
45923;"mydb";4732;10;"postgres";"";"127.0.0.1";1185;"2011-01-22
21:24:57.156+02";"2011-01-22 21:25:24.109+02";"2011-01-22
21:25:24.109+02";f;"
I will try to run it on next crash if users will not restart server before.
> and
> select * from pg_locks;
I ran it from pgadmin. It shows now :
"relation";45923;10985;;;"";;;;;"4/241";4732;"AccessShareLock";t
"virtualxid";;;;;"4/241";;;;;"4/241";4732;"ExclusiveLock";t
I will try to run it on next crash if users will not restart server before.
> A little practice up front might help. When the system is broke, you can
> interrogate it to see what its doing. Hopefully we'll see something
> locked, and a bunch of things waiting.
Users can restart server without contacting me. For this reason I
asked for automated dump.
Andrus.
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2011-01-22 21:08:41 | Re: Server stops responding in every week |
Previous Message | Greg Smith | 2011-01-22 18:18:29 | Re: SHMMAX and SHMALL question |