Re: Minimum selectivity estimate for LIKE 'prefix%' - Mailing list pgsql-patches

From Tom Lane
Subject Re: Minimum selectivity estimate for LIKE 'prefix%'
Date
Msg-id 14389.1205773018@sss.pgh.pa.us
Whole thread Raw
In response to Re: Minimum selectivity estimate for LIKE 'prefix%'  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-patches
Peter Eisentraut <peter_e@gmx.net> writes:
> Am Donnerstag, 6. M�rz 2008 schrieb Tom Lane:
>> I attach a proposed patch against HEAD for this. �It's a bit long
>> but most of the bulk is refactoring eqsel() to make it easy to use from
>> prefix_selectivity(). �The intellectual content is just in the last
>> diff hunk.

> Looking at the patch as committed here
> <http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/selfuncs.c.diff?r1=1.243;r2=1.244>,
> I am confused by one hunk:

Ack, that's a bug --- I was looking at the use of opproc by
ineq_histogram_selectivity and failed to notice make_greater_string
using it too.  Will fix.

            regards, tom lane

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Patch Status
Next
From: Josh Berkus
Date:
Subject: Re: [HACKERS] [0/4] Proposal of SE-PostgreSQL patches