n Sat, Jun 12, 2010 at 3:21 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: > Performance test the index: > > create test_index on table (lower(fieldname)); > > versus storing the emails in lower case. Some quick testing on that tells me that storing in lower case will be about twice as fast at retrieval. But we're talking things like 1ms versus 2ms. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
