Re: PATCH: CITEXT 2.0 v2

From: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: PATCH: CITEXT 2.0 v2
Date: 2008-07-07 17:20:57
Message-ID: AA140A00-93A7-4071-AA49-FD7E47ECEFD3@kineticode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Jul 7, 2008, at 08:01, Andrew Dunstan wrote:

> What does still bother me is its performance. I'd like to know if
> any measurement has been done of using citext vs. a functional index
> on lower(foo).

That's a good question. I can whip up a quick test by populating a
column full of data and trying both, but I'm no performance testing
expert. Anyone else know more about such performance testing who can
help out?

Many Thanks,

David

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2008-07-07 17:28:51 Re: Proposal of SE-PostgreSQL patches [try#2]
Previous Message David E. Wheeler 2008-07-07 17:20:03 Re: PATCH: CITEXT 2.0 v2