Re: SELECT speed with LIKE

Поиск
Список
Период
Сортировка
От Robert W. Berger
Тема Re: SELECT speed with LIKE
Дата
Msg-id 27028.3164232753@porter.vtiscan.com
обсуждение исходный текст
Ответ на Re: SELECT speed with LIKE  (Jim Richards <grumpy@cyber4.org>)
Список pgsql-general
The locale problem only affects the speed once it decides to use an index;
it does not affect whether it chooses an index or sequential scan.

Try doing a VACUUM ANALYZE; that often makes it start using index scans.


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