[traven-tech] postgres thrashing?
gdm at fifthhorseman.net
Fri Nov 25 22:36:48 PST 2005
-----BEGIN PGP SIGNED MESSAGE-----
john duda wrote:
> i don't know what the avergae traven performance is really like, but
> this alarms me:
> top - 03:05:44 up 1 day, 19:26, 1 user, load average: 2.64, 1.88, 1.79
> Tasks: 84 total, 3 running, 81 sleeping, 0 stopped, 0 zombie
> Cpu(s): 98.0% us, 1.7% sy, 0.0% ni, 0.0% id, 0.0% wa, 0.0% hi, 0.3% si
> Mem: 3108316k total, 3065116k used, 43200k free, 406200k buffers
> Swap: 2097140k total, 0k used, 2097140k free, 1218412k cached
> PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
> 20639 postgres 25 0 270m 264m 262m R 83.6 8.7 428:18.65 postmaster
> 19414 tomcat4 25 0 1308m 1.1g 27m S 15.6 36.8 279:09.17 java
> 19389 postgres 15 0 7256 2180 1624 S 0.7 0.1 4:21.38 postmaster
> 19388 postgres 15 0 7972 2980 1616 S 0.3 0.1 5:42.24 postmaster
if i'm right, load average is often around 5, plus i think this is a fairly
consistent level of cpu usage as well :/
at the recent uk tech meeting, there was an acknowledgement that we need to do
something about this, as traven was only ever meant to be a stop-gap. however,
it has now turned into one of the major mir production servers, which was not
the original plan but it looks as if it will stay that way for at least some time.
the probable plan was that we would get another box that could act locally (i.e.
in the same colo as traven) as a postgres server, hence taking a lot of the load
off traven. i am not quite sure where we got to with this - someone else from
the uk might like to comment - but i think we should get a move on.
> earlier today there was two crazy postmasters going and load was
> closer to 6...is this normal for traven, or is something weird?
full stats available (via munin) at
this box is getting used!
love and solidarity,
i have a NEW key:
gpg --keyserver pgp.mit.edu --recv-keys 594B97C2
Key fingerprint = 7B70 F22D F275 D111 3A04 F9EE 0E25 4944 594B 97C2
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (Darwin)
-----END PGP SIGNATURE-----
More information about the traven-tech