Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: [PATCHES] Minimum selectivity estimate for LIKE 'prefix%'
- From: Peter Eisentraut <peter_e(at)gmx(dot)net>
- To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- Cc: pgsql-hackers(at)postgresql(dot)org
- Subject: Re: [PATCHES] Minimum selectivity estimate for LIKE 'prefix%'
- Date: Mon, 31 Mar 2008 18:33:26 +0200
- Message-id: <200803311833.27131.peter_e@gmx.net> <text/plain>
Am Montag, 31. März 2008 schrieb Tom Lane: > Peter Eisentraut <peter_e(at)gmx(dot)net> writes: > > OK, first results with this patch are in: The selectivity estimations are > > adjusted nicely, but the cost calculation doesn't change at all. Before: > > I've forgotten the context ... what's the whole query and plan again? > And which PG version exactly? Please see http://archives.postgresql.org/pgsql-hackers/2008-01/msg00048.php
- Follow-Ups:
- References:
- Re: [PATCHES] Minimum selectivity estimate for LIKE 'prefix%'
- From: Peter Eisentraut
- Re: [PATCHES] Minimum selectivity estimate for LIKE 'prefix%'
- From: Tom Lane
- Re: [PATCHES] Minimum selectivity estimate for LIKE 'prefix%'
- Prev by Date: Re: [GENERAL] ANALYZE getting dead tuple count hopelessly wrong
- Next by Date: Re: POSIX shared memory support
- Previous by thread: Re: [PATCHES] Minimum selectivity estimate for LIKE 'prefix%'
- Next by thread: Re: [PATCHES] Minimum selectivity estimate for LIKE 'prefix%'
- Indexes: