In CVS, lower() has been removed from all mailbox queries to allow for case sensitive mailbox names (as is common for Unix filesystem based mailers).
Not sure if this behaviour has been changed in 1.2.x, though. Aaron Thomas Mueller <[EMAIL PROTECTED]> said: > Hi, > > I had 800.000 SeqScans on the mailboxes table in 5 days. The only > explanation I have is this missing index: > CREATE INDEX mailboxes_name_low_idx ON mailboxes(lower(name)); > > The INBOX is searched using lower(name). > > > Thomas > -- > http://www.tmueller.com for pgp key (95702B3B) > _______________________________________________ > Dbmail-dev mailing list > Dbmail-dev@dbmail.org > http://twister.fastxs.net/mailman/listinfo/dbmail-dev > --
