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