Re: Best way to store case-insensitive data?

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Mike Christensen <mike(at)kitchenpc(dot)com>
Cc: Michal Politowski <mpol(at)charybda(dot)icm(dot)edu(dot)pl>, pgsql-general(at)postgresql(dot)org
Subject: Re: Best way to store case-insensitive data?
Date: 2010-06-12 21:26:01
Message-ID: AANLkTincVtAiB5kp8jAl-i1iHwf7ktkJTxNBWDLVEQsj@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2010-06-12 22:59:06 Re: Re: Error on Windows server could not open relation base/xxx/xxx Permission denied
Previous Message Scott Marlowe 2010-06-12 21:21:21 Re: Best way to store case-insensitive data?