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

From Tom Lane
Subject Re: Text Selectivity Operators in String Types
Date
Msg-id 3153.1219087128@sss.pgh.pa.us
Whole thread Raw
In response to Text Selectivity Operators in String Types  ("David E. Wheeler" <david@kineticode.com>)
Responses Re: Text Selectivity Operators in String Types  ("David E. Wheeler" <david@kineticode.com>)
List pgsql-hackers
"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.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Overhauling GUCS
Next
From: Josh Berkus
Date:
Subject: Re: Overhauling GUCS