[Mailman-Users] Trouble with LARGE mailing list

[Juergen Geinitz]

Hello,
I have a mailing list here running for one of our customers
which is getting extremely large and therefore slow.
The list is a newsletter list with one post a week - that doesn't
harm me. But I hav about 500 new subscribes a day which makes up to now
about 150000 members - and thats my problem:
the config.db is
-rw-rw----    1 www-data www-data 15587680 Apr 18 14:13 config.db

and therefore is blowing my main memory. Lokk at this output of "top"
31084 www-data  18   0  81M           R    48.7 10.8   0:07
/usr/bin/python -S /usr/lib/mailman-aldi/scripts/driver subscribe
31262 www-data  20   0  42M           R    48.1  5.5   0:03
/usr/bin/python -S /usr/lib/mailman-aldi/scripts/driver subscribe
31260 geinitz   13   0 2456           R     0.9  0.3   0:00 top
30983 www-data   9   0  73M do_select S     0.3  9.7   0:11
/usr/bin/python -S /usr/lib/mailman-aldi/scripts/driver subscribe
31102 www-data   9   0  42M do_select S     0.3  5.6   0:04
/usr/bin/python -S /usr/lib/mailman-aldi/scripts/driver subscribe
31120 www-data  10   0  73M do_select S     0.3  9.7   0:11
/usr/bin/python -S /usr/lib/mailman-aldi/scripts/driver subscribe
31219 www-data   9   0  42M do_select S     0.3  5.6   0:04
/usr/bin/python -S /usr/lib/mailman-aldi/scripts/driver subscribe
31240 www-data   9   0  42M do_select S     0.3  5.6   0:04
/usr/bin/python -S /usr/lib/mailman-aldi/scripts/driver subscribe
   11 root       9   0    0 mosix_mem SW    0.1  0.0  10:07 memsorter
30682 www-data   9   0  984 do_select S     0.1  0.1   0:05
/usr/bin/python -S /usr/lib/mailman-aldi/scripts/driver subscribe
31220 www-data   9   0  42M do_select S     0.1  5.6   0:03
/usr/bin/python -S /usr/lib/mailman-aldi/scripts/driver subscribe
31222 www-data   9   0  42M do_select S     0.1  5.6   0:03
/usr/bin/python -S /usr/lib/mailman-aldi/scripts/driver subscribe
31242 www-data   9   0  42M do_select S     0.1  5.6   0:03
/usr/bin/python -S /usr/lib/mailman-aldi/scripts/driver subscribe

so every subscribe is between 40 an 80 M in core. At the moment the
system is running an own apache
for this with a connect limit of 15 which gives 768M main memory used
plus 200M swap. When I remove
the apache limit, the system goes into swapping - more subscribe
requests arrive - less memory
an about 5 minutes later - BANG

Any Idea?
Any hint?

Regards
	Juergen
-- 
novalis media
  Ein Bereich der Vereinigte Verlagsanstalten GmbH -
    http://www.vva.de
    http://www.novalis-media.de
Geschaeftsfuehrer Stefan Meutsch HRB 658 Duesseldorf