Re: specific query (not all) on Pg8 MUCH slower than Pg7

[Susan Russo <russo@xxxxxxxxxxxxxxxxxx>]

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.!).

Thanks again - will report back soon.

Susan