Thomas Mueller wrote: > Hi Aaron, > > >>now I have only one slow query left - unfortunately I have no idea why > >>it is that slow. The mailbox contains ~1800 mails. It takes 45 seconds > >>to open it: > >> > >>SELECT seen_flag, answered_flag, deleted_flag, flagged_flag, draft_flag, > >>recent_flag, TO_CHAR(internal_date, 'YYYY-MM-DD HH24:MI:SS' ), rfcsize, > >>message_idnr FROM dbmail_messages msg, dbmail_physmessage pm WHERE pm.id > >>= msg.physmessage_id AND message_idnr BETWEEN '1' AND '417966' AND > >>mailbox_idnr = '81' AND status < '2' ORDER BY message_idnr ASC > > > > Wild. Swapping in the MySQL function for TO_CHAR, then running on my > > mailbox takes 0.32 seconds for 4518 rows (I didn't change your numbers > > except the mailbox idnr). > > That is fast (MyISAM or InnoDB?), but I would expect something below 1s too. > > If no one has an idea what could be wrong I'll ask on the PostgreSQL sql > list tomorrow.
At this point, you might consider posting to pgsql-performance as well as (or, perhaps, instead of) pgsql-sql. -- Kevin Brown [EMAIL PROTECTED]
