Re: Minimum selectivity estimate for LIKE 'prefix%'

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

Am Donnerstag, 6. März 2008 schrieb Tom Lane:
> To help out Peter's client, who's running 8.1.x, we'd have to backpatch
> at least that far.  We backpatched the last round of LIKE selectivity
> fixes to 8.1, so I don't have too much hesitation about doing the same
> here.

Thanks for the offer. Personally, I'd be OK with not backpatching and dealing
with the patch myself. We've patched that area before, but I'm not sure what
the original cause of that was, but this here sounds more like a feature
improvement.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Chernow 2008-03-07 18:36:22 Re: Commitfest status
Previous Message Peter Eisentraut 2008-03-07 18:25:25 Maximum statistics target

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2008-03-07 20:06:24 Re: [PATCHES] a tsearch2 (8.2.4) dictionary that only filters out stopwords
Previous Message Teodor Sigaev 2008-03-07 13:56:40 Re: [BUGS] BUG #3975: tsearch2 index should not bomb out of 1Mb limit