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
