Re: Text Selectivity Operators in String Types - Mailing list pgsql-hackers

From David E. Wheeler
Subject Re: Text Selectivity Operators in String Types
Date
Msg-id 85793931-0065-46F4-8A2E-B88AEA891215@kineticode.com
Whole thread Raw
In response to Re: Text Selectivity Operators in String Types  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Aug 18, 2008, at 12:18, Tom Lane wrote:

> "David E. Wheeler" <david@kineticode.com> writes:
>> From what depesz sees, the eqsel and eqjoinsel functions might be a
>> bit too aggressive in recommending the use of indexes.
>
> He presented absolutely 0 evidence to back up that opinion.
>
>> So I was wondering, since in CVS HEAD citext is able to identify its
>> type category as string, might there also be some way to use the same
>> estimator functions in the citext operators as are used for text?
>
> Those are the same estimator functions.

Oh. Okay then. That was easy. Thanks!

Best,

David



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Overhauling GUCS
Next
From: "Kevin Grittner"
Date:
Subject: Re: IN vs EXISTS equivalence