Re: specific query (not all) on Pg8 MUCH slower than Pg7 - Mailing list pgsql-performance

Susan Russo wrote:
> Hi,
>
> >You could always try
> >
> >  CREATE INDEX test_index ON dbxref (accession varchar_pattern_ops);
>
> WOW!  we're now at runtime 0.367ms on Pg8
>
> Next step is to initdb w/C Locale (tonight) (Thanks Tom et al.!).

That's alternative to the pattern_ops index; it won't help you obtain a
plan faster than this one.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.