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.
