Re: cannot get stable function to use index

Поиск
Список
Период
Сортировка
От Jim Nasby
Тема Re: cannot get stable function to use index
Дата
Msg-id 56855F25.1060703@BlueTreble.com
обсуждение исходный текст
Ответ на Re: cannot get stable function to use index  (Andy Colson <andy@squeakycode.net>)
Список pgsql-general
On 12/30/15 2:12 PM, Andy Colson wrote:
>>
>> random_page_cost = 1
>>
>
> Humm, nope.  I removed the config option, restart PG, then analyzed the
> search table:

FYI, you can set that inside any session, any time you want. What's in
postgresql.conf is just the default value.

(For that matter, you can also set a default for than on a specific
database, or a specific user, using ALTER DATABASE SET or ALTER USER SET.)
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com


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

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: Efficiently Triggering Autovacuum Analyze?
Следующее
От: George Woodring
Дата:
Сообщение: SSL connection issue via perl