Re: [PATCHES] Minimum selectivity estimate for LIKE 'prefix%'

2008-03-17 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> 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

Re: [PATCHES] Minimum selectivity estimate for LIKE 'prefix%'

2008-03-17 Thread Peter Eisentraut
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 com

Re: [PATCHES] Minimum selectivity estimate for LIKE 'prefix%'

2008-03-07 Thread Peter Eisentraut
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. Pe

[PATCHES] Minimum selectivity estimate for LIKE 'prefix%'

2008-03-06 Thread Tom Lane
Peter complained awhile back about unrealistically small selectivity estimates for LIKE with a fixed-prefix pattern: http://archives.postgresql.org/pgsql-hackers/2007-12/msg00939.php I had suspected that this was related to the locale-specific problems we fixed a few months ago, but having finally