Svenne Krap <svenne(dot)lists(at)krap(dot)dk> wrote:
> I am happy to run whatever relevant tests you can dream up, but I am
> fresh out of ideas :)
psql regression
begin;
drop index dupindexcols_i;
SELECT count(*) FROM dupindexcols
WHERE f1 > 'WA' and id < 1000 and f1 ~<~ 'YX';
rollback;
select f1 from dupindexcols where f1 like 'W%' ORDER BY f1;
What are the results?
--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company