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)

Reply via email to