James Cloos <[email protected]> wrote: > create index mb_name_own_idx on mb ( lower(name), ownerid ); > WHERE lower(name) = lower('foo@bar') AND ownerid=7; If you expect to be using an equality test on ownerid, you should put that first in the index. BTW, this is starting to sound more like something for the pgsql-performance list than the pgsql-hackers list. -Kevin
-- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
