Re: Minimum selectivity estimate for LIKE 'prefix%'

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: Minimum selectivity estimate for LIKE 'prefix%'
Date: 2008-03-17 16:56:58
Message-ID: 14389.1205773018@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> Am Donnerstag, 6. Mrz 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Smith 2008-03-17 17:04:00 Re: Commit fest?
Previous Message Magnus Hagander 2008-03-17 16:55:05 Re: Commit fest?

Browse pgsql-patches by date

  From Date Subject
Next Message Josh Berkus 2008-03-17 17:04:53 Re: [0/4] Proposal of SE-PostgreSQL patches
Previous Message Bruce Momjian 2008-03-17 16:54:32 Re: Patch Status