Re: [PERFORM] query plan with index having a btrim is different for strings of different length

[Tom Lane]

BTW, if your queries typically constrain both lastname and firstname,
it'd likely be worthwhile to make a 2-column index on
        lower(btrim(x_lastname)), lower(btrim(x_firstname))

                        regards, tom lane

-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance