James Cloos <cl...@jhcloos.com> 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 (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
