Re: mailing list archiver chewing patches

Matteo Beccati <php@beccati.com>

From: Matteo Beccati <php@beccati.com>

To: Dave Page <dpage@pgadmin.org>

Cc: Dimitri Fontaine <dfontaine@hi-media.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-14T14:32:13Z

Lists: pgsql-hackers

Il 14/01/2010 14:46, Dave Page ha scritto:
> 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.

Sure, I will give it a try in the evening or tomorrow.


Cheers
-- 
Matteo Beccati

Development & Consulting - http://www.beccati.com/