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

Поиск
Список
Период
Сортировка
От Susan Russo
Тема Re: specific query (not all) on Pg8 MUCH slower than Pg7
Дата
Msg-id 200705081519.l48FJtsT028597@larrys.harvard.edu
обсуждение исходный текст
Ответ на specific query (not all) on Pg8 MUCH slower than Pg7  (Susan Russo <russo@morgan.harvard.edu>)
Ответы Re: specific query (not all) on Pg8 MUCH slower than Pg7
Список pgsql-performance
Дерево обсуждения 
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

В списке pgsql-performance по дате отправления: