Re: mailing list archiver chewing patches - Mailing list pgsql-hackers

From Dave Page
Subject Re: mailing list archiver chewing patches
Date
Msg-id 937d27e11001140636i2d767ba1mc32e5eeb8130ce38@mail.gmail.com
Whole thread Raw
In response to Re: mailing list archiver chewing patches  (Matteo Beccati <php@beccati.com>)
List 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


pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Streaming replication, retrying from archive
Next
From: Vincenzo Romano
Date:
Subject: [PL/PgSQL] EXECUTE...USING enhancement proposal