Re: contrib/citext versus collations

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org, lr(at)pcorp(dot)us
Subject: Re: contrib/citext versus collations
Date: 2011-06-06 23:35:37
Message-ID: 15559.1307403337@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"David E. Wheeler" <david(at)kineticode(dot)com> writes:
> On Jun 6, 2011, at 1:14 PM, Tom Lane wrote:
>> ... One bit of infrastructure that might be a good idea is
>> a flag to indicate whether an equality operator's behavior is
>> potentially collation-dependent, so that we could avoid taking
>> performance hits in the normal case.

> That sounds like a good idea.

BTW, it struck me shortly after sending this that we'd already discussed
the idea of a flag in pg_proc showing whether a function pays attention
to collation. We could of course use that for this purpose.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2011-06-06 23:43:30 Re: reducing the overhead of frequent table locks - now, with WIP patch
Previous Message Robert Creager 2011-06-06 23:30:12 CREATE FUNCTION hang on test machine polecat on HEAD