Re: mailing list archiver chewing patches

From: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Andrew Dunstan <andrew(at)dunslane(dot)net>, Tim Bunce <Tim(dot)Bunce(at)pobox(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: mailing list archiver chewing patches
Date: 2010-01-11 10:18:47
Message-ID: 87my0lvta0.fsf@hi-media-techno.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-www

Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> Absolutely. The month boundary problem boils down to the fact that
> Mhonarc does not scale very well, so we can't have mboxes that are too
> large. This is why most people split their archives per month, and then
> each month is published as an independent Mhonarc output archive. It's
> a horrid solution.
>
>> Are our indexing and searches provided by MHonArc or maintained by the
>> community?
>
> Searches are completely external to mhonarc.

Changing the MHonArc solution would probably mean adapting them, I
guess, or proposing a new solution with compatible output for the
searching to still work…

>> How helpful considering alternatives, such as AOX (which runs
>> atop PostgreSQL and would offer anonymous IMAP facility over the
>> archives) would be?
>>
>> Of course it'll boil down to who's maintaining the current solution and
>> how much time is allocated to this, the solution research and migration
>> would have to fit in there I suppose. Same as pgfoundry. But still,
>> should we talk about it?
>
> There's some talk about writing our own archiving system,
> database-backed. There have been a few false starts but no concrete
> result so far. We need a lot more manpower invested in this problem.
> If there's interest, let's talk about it.

AOX is already a database backed email solution, offering an archive
page with searching. I believe the searching is baked by tsearch
indexing. That's why I think it'd be suitable.

They already archive and offer search over one of our mailing lists, and
from there it seems like we'd only miss the user interface bits:

http://archives.aox.org/archives/pgsql-announce

I hope the UI bits are not the most time demanding one.

Is there someone with enough time to install aox somewhere and have it
subscribed to our lists?

> My daugher was born yesterday and I'm having a bit of a calm before the
> storm because she's not coming home until Tuesday or so (at this time of
> the day, that is, because I have to take care of the other daughter).
> I'll be probably away for (at least) a week when she does; and I'll
> probably have somewhat of a shortage of spare time after that.

Ahaha :)
IME that's not the shortage of spare time which ruins you the most as
the lack of energy when you do have this little precious resource
again, very few piece of it atime.

Regards,
--
dim

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Matteo Beccati 2010-01-11 11:53:08 Re: mailing list archiver chewing patches
Previous Message Arnaud Betremieux 2010-01-11 10:05:45 Re: Listen / Notify - what to do when the queue is full

Browse pgsql-www by date

  From Date Subject
Next Message Matteo Beccati 2010-01-11 11:53:08 Re: mailing list archiver chewing patches
Previous Message Magnus Hagander 2010-01-11 09:46:10 Re: mailing list archiver chewing patches