[traven-tech] postgres thrashing?

GarconDuMonde gdm at fifthhorseman.net
Fri Nov 25 22:36:48 PST 2005

Hash: SHA1


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

Version: GnuPG v1.2.4 (Darwin)


More information about the traven-tech mailing list