> 2. PostgreSQL 7.4 speed: > > dbmail-util -ay run for 11 hours(!) to fix the header caches etc. and > IMAP was _very_ slow after the upgrade. Especially fetching message > headers was 10 or 100 times slower than with 2.0.10. I found out that the > problem is that the queries sent to PostgreSQL have conditions like > physmessage_id IN (573485) > in it, but PostgreSQL 7.4 can only use indexes if the condition is > written as > physmessage_id IN (753485::bigint) > > Meanwhile I upgraded to PostgreSQL 8.1.4 which does not have this > problem with using indexes when types don't match exactly. IMAP is now at > least as fast as with 2.0.10.
Sounds like we should strongly recommend PostgreSQL 8.1 or later (Though I think 8.0 can do the above mentioned optimization, but I'm not sure.) in the release notes and possibly the DBMail documentation. I don't think it's worth while to optimize DBMail for older releases of PostgreSQL. Matt
