Paul,
> > Keen! Hopefully I'll be able to do a write up on replicated e-mail
> > with dbmail ...
>
> On postgresql perhaps?
What, like I'd use something else? ;-)
> In 2.3+ attachments are indeed stored as atomic blobs in the mimeparts
> table. The rfc822 header part of the complete message, and the
> headerpart of attached mimeparts is also stored as blob in the mimeparts
> table. Mimeparts are linked into actual messages by the partlists table.
> Retrieval put the right blobs in the right order and depth, separated by
> the correct boundary.
Are you using BYTEA or LO for PostgreSQL? The former is vastly easier to
manage.
> More to the point: it looks like I
> have to rewrite the whole mime parser from scratch. GMime is not
> threadsafe, and adding mutex locks appears to completely kill
> performance. But then again, things may be not quite that bad after all.
> I havent figured it out quite yet. Which makes it just one of those
> things: they take time to work themselves out.
Hmmm. I don't know mime parsers *at all*. Are you storing the attachments
in MIME form, or in original format?
--
--Josh
Josh Berkus
PostgreSQL @ Sun
San Francisco
_______________________________________________
DBmail mailing list
DBmail@...
https://mailman.fastxs.nl/mailman/listinfo/dbmail
