Re: [Dovecot] Is Dovecot able to use PostgreSQL to store mailboxes?

On 22.6.2004, at 04:49, Tom Allison wrote:

I had a conversation with the same fellow a while back.

I'm told that dbmail is actually very fast in mail retrieval. But I was unable to confirm it myself.

It could be fast, but it couldn't be faster than doing "cat mailfile", which is basically what maildir clients do.

In short, they store the entire header in one field and the entire body in another field. Hardly optimized for the three or four most common sorts (date, subject, sender, threaded)

Sorting could be completely done by SQL server with ORDER BY, but threading would require just fetching a few headers and doing it internally. Dovecot 1.0's cache file btw. keeps the commonly used headers stored in it.