Re: mailing list archiver chewing patches

Dave Page <dpage@pgadmin.org>

From: Dave Page <dpage@pgadmin.org>

To: Matteo Beccati <php@beccati.com>

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:36:35Z

Lists: pgsql-hackers

On Thu, Jan 14, 2010 at 8:02 PM, Matteo Beccati <php@beccati.com> wrote:
> 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.

Thanks :-)


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