Re: mailing list archiver chewing patches

Dave Page <dpage@pgadmin.org>

From: Dave Page <dpage@pgadmin.org>
To: Dimitri Fontaine <dfontaine@hi-media.com>
Cc: Matteo Beccati <php@beccati.com>, Aidan Van Dyk <aidan@highrise.ca>, Magnus Hagander <magnus@hagander.net>, Abhijit Menon-Sen <ams@toroid.org>, Alvaro Herrera <alvherre@commandprompt.com>, Andrew Dunstan <andrew@dunslane.net>, Tim Bunce <Tim.Bunce@pobox.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2010-01-14T13:46:09Z
Lists: pgsql-hackers
On Thu, Jan 14, 2010 at 7:09 PM, Dimitri Fontaine
<dfontaine@hi-media.com> wrote:
> Matteo Beccati <php@beccati.com> writes:
>> I've extended AOX with a trigger that takes care of filling a separate table
>> that's used to display the index pages. The new table also stores threading
>> information (standard headers + Exchange headers support) and whether or not
>> the email has attachments.
>>
>> Please check the updated PoC: http://archives.beccati.org/
>
> Looks pretty good, even if some thread are still separated (this one for
> example), and the ordering looks strange.
>
> Seems to be right on tracks, that said :)

Yup.

Matteo - Can you try loading up a lot more of the old mbox files,
particularly the very early ones from -hackers? It would be good to
see how it copes under load with a few hundred thousand messages in
the database.

-- 
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com