Re: index with LIKE

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: index with LIKE
Дата
Msg-id 1087416625.1582.39.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Re: index with LIKE  ("Henrik Steffen" <steffen@city-map.de>)
Ответы Re: index with LIKE  ("Henrik Steffen" <steffen@city-map.de>)
Список pgsql-general
1: Is index capable of being used on the slaves, or are they just making
bad decisions?  Try disabling seq scans on the slave servers for testing
and see if they can use the index.  Use "set enable_seqscan = FALSE;"

If they can't use the index then, then they are likely in the wrong
locale, and you'll need to re initdb them to get them to use an index.

If they can use the index then we have tuning issue.


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

Предыдущее
От: Chris Browne
Дата:
Сообщение: Re: why no answer? [Fwd: backup and restore just with use of jdbc?]
Следующее
От: Robert Fitzpatrick
Дата:
Сообщение: Database accesss using plperl