Ahoi,
has anyone
A) spent thoughts (and is willing to share them) about database sizing for an mailman3-production-system?
like: space per user + other data + estimated growth = warning to give to my database-admin
or B) has some empirical values and would like to share?
greetings aiz
P.S. this post is related to another about database contents
On 1/22/25 6:22 AM, Alexander Inzinger-Zrock via Mailman-users wrote:
B) has some empirical values and would like to share?
mail.python.org has 195 lists with 53394 members. Its PostgerSQL database is currently 18 gigabytes.
This includes HyperKitty archives, some of which are quite large. The hyperkitty_email table together with the hyperkitty_attachment table contain the contents of every message in the archive.
lists.mailman3.org has only one significant list with 658 members and currently archives 2267 messages not counting this one. Its PostgerSQL database is currently 193 megabytes.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
On 1/22/25 3:49 PM, Mark Sapiro wrote:
mail.python.org has 195 lists with 53394 members. Its PostgerSQL database is currently 18 gigabytes.
PostgreSQL not PostgerSQL and likewise below.
I neglected to mention the Xapien search index which is 41 gigabytes.
This includes HyperKitty archives, some of which are quite large. The hyperkitty_email table together with the hyperkitty_attachment table contain the contents of every message in the archive.
lists.mailman3.org has only one significant list with 658 members and currently archives 2267 messages not counting this one. Its PostgerSQL database is currently 193 megabytes.
And the Xapien search index here is 382 megabytes.
I.e., in both cases the Xapien search index is on the order of twice as big as the PostgreSQL database.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
On 1/22/25 09:22, Alexander Inzinger-Zrock via Mailman-users wrote:
has some empirical values and would like to share?
I have a system with about ~15k users, and archives from 1992. I have the archives in the maildir format as well as hyperkitty.
/opt/mailman = 8.2 GiB mailman postgres db ~50 MiB mailmanweb postgres db ~ 1GiB
-- Bryan Fields
727-409-1194 - Voice http://bryanfields.net
participants (3)
-
Alexander Inzinger-Zrock -
Bryan Fields -
Mark Sapiro