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.

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to