Re: Text Selectivity Operators in String Types

From: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Text Selectivity Operators in String Types
Date: 2008-08-18 19:47:32
Message-ID: 85793931-0065-46F4-8A2E-B88AEA891215@kineticode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Aug 18, 2008, at 12:18, Tom Lane wrote:

> "David E. Wheeler" <david(at)kineticode(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2008-08-18 19:47:43 Re: IN vs EXISTS equivalence
Previous Message Tom Lane 2008-08-18 19:40:24 Re: Overhauling GUCS