Re: cannot get stable function to use index - Mailing list pgsql-general

From Jim Nasby
Subject Re: cannot get stable function to use index
Date
Msg-id 56855F25.1060703@BlueTreble.com
Whole thread Raw
In response to Re: cannot get stable function to use index  (Andy Colson <andy@squeakycode.net>)
List 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 by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Efficiently Triggering Autovacuum Analyze?
Next
From: George Woodring
Date:
Subject: SSL connection issue via perl