On Sat, Apr 11, 2009 at 01:07:29AM +0800, Paul Wise wrote: > For some queries whohas causes my machine (with 1.5GB RAM) to enter swap > hell. As an example it uses over a gigabyte of ram for 'whohas sqlite'.
Ok, I reproduce this exactly. Removing the Debian-distributed patches
gets the memory use for this query down to nearly 900M, so I think the
difference is just that there are more repositories available through
the patches.
I suspect this is down to the threading model, and indeed
using --no-threads gets memory use for this query down to ~85M:
9933 jona 20 0 85816 38m 2484 S 5 1.0 0:00.98 perl
debpackages/whohas-0.23/program/whohas sqlite --no-threads
It's a much better number, but of course there's a speed tradeoff. In
the meantime it's going upstream if it hasn't already (I don't
remember), because I think the approach to threads needs looking at more
closely.
--
Jonathan Wiltshire
PGP/GPG: 0xDB800B52 / 4216 F01F DCA9 21AC F3D3 A903 CA6B EA3E DB80 0B52
signature.asc
Description: Digital signature
