A NOTE has been added to this issue. ====================================================================== http://www.dbmail.org/mantis/view.php?id=539 ====================================================================== Reported By: paul Assigned To: paul ====================================================================== Project: DBMail Issue ID: 539 Category: IMAP daemon Reproducibility: always Severity: minor Priority: normal Status: assigned target: ====================================================================== Date Submitted: 17-Mar-07 16:42 CET Last Modified: 19-Mar-07 22:11 CET ====================================================================== Summary: Mailclient times out opening large mailboxes Description: When a mailclient like Thunderbird opens a large mailfolder with many unread messages an error is returned to the user saying that opening the folder takes too long. ======================================================================
---------------------------------------------------------------------- cmayo - 19-Mar-07 20:27 ---------------------------------------------------------------------- I see the same timeouts with 2.2.4. Analysing the Postgresql 8.1.8 logs with pgfouine updating the recent flags with: update dbmail_messages set recent_flag = 0 where message_idnr in is taking a lot of time. ---------------------------------------------------------------------- paul - 19-Mar-07 22:11 ---------------------------------------------------------------------- Interesting. As part of this bug I'm actually working on avoiding long-running queries against the envelope and header caches. Such queries shouldn't scale 1/n with the number of messages in a mailbox before returning some data to the client. At first glance however, your case smells like a different beast. Why is postgres taking so long to run the update query that flushes recent flags? I assume that postgres doesn't suffer from locking issues due to mvcc. Right? Are you sure this is the query that is triggering timeouts in the client? Issue History Date Modified Username Field Change ====================================================================== 17-Mar-07 16:42 paul New Issue 17-Mar-07 16:42 paul Status new => assigned 17-Mar-07 16:42 paul Assigned To => paul 19-Mar-07 20:27 cmayo Note Added: 0001927 19-Mar-07 20:28 cmayo Issue Monitored: cmayo 19-Mar-07 22:11 paul Note Added: 0001928 ====================================================================== _______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
