Postgres Pro
Downloads
Home   >   mailing lists

Thread: Disable hot-update functionality

Disable hot-update functionality

From
Rohit Goyal
Date:
Hi All, 

Is there any ways by which i can disable the hot-update functionality?

--
Regards,
Rohit Goyal

Re: Disable hot-update functionality

From
Fabrízio de Royes Mello
Date:

On Wed, Mar 5, 2014 at 5:32 PM, Rohit Goyal <rhtgyl.87@gmail.com> wrote:
>
> Hi All,
>
> Is there any ways by which i can disable the hot-update functionality?
>

Why do you want do that?

Grettings,

--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Timbira: http://www.timbira.com.br
>> Blog sobre TI: http://fabriziomello.blogspot.com
>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello

Re: Disable hot-update functionality

From
Jeff Janes
Date:
On Wed, Mar 5, 2014 at 12:32 PM, Rohit Goyal <rhtgyl.87@gmail.com> wrote:
Hi All, 

Is there any ways by which i can disable the hot-update functionality?

Build an index on a volatile column.  For example, to force pgbench to bypass HOT updates for testing purposes I build an index on pgbench_accounts (abalance).

Cheers,

Jeff