Re: Best way to store case-insensitive data? - Mailing list pgsql-general

n Sat, Jun 12, 2010 at 3:21 PM, Scott Marlowe <scott.marlowe@gmail.com> 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.