PostgreSQL参数学习:vacuum_defer_clean_age

官方文档:

http://www.postgresql.org/docs/9.3/static/runtime-config-replication.html

为了防止slave端读取数据时,因为读到的是旧有数据而被强制取消,设定了这么一个以transaction为单位的值。

就是可以保证经过这么多的trsanction后,数据仍然得以为slave 几点到读取而保留。 

 

PostgreSQL参数学习:vacuum_defer_clean_age
vacuum_defer_cleanup_age (integer)
Specifies the number of transactions by which VACUUM and HOT updates will defer cleanup of dead row versions. The default is zero transactions, meaning that dead row versions can be removed as soon as possible, that is, as soon as they are no longer visible to any open transaction. You may wish to set this to a non-zero value on a primary server that is supporting hot standby servers, as described in Section 25.5. This allows more time for queries on the standby to complete without incurring conflicts due to early cleanup of rows. However, since the value is measured in terms of number of write transactions occurring on the primary server, it is difficult to predict just how much additional grace time will be made available to standby queries. This parameter can only be set in the postgresql.conf file or on the server command line.

You should also consider setting hot_standby_feedback on standby server(s) as an alternative to using this parameter.
PostgreSQL参数学习:vacuum_defer_clean_age

 

参考:

http://blog.sina.com.cn/s/blog_773523db0101054f.html

结束







本文转自健哥的数据花园博客园博客,原文链接:http://www.cnblogs.com/gaojian/p/3355319.html,如需转载请自行联系原作者

上一篇:基于Bootstrap的日历控件和日期选择插件


下一篇:《jQuery、jQuery UI及jQuery Mobile技巧与示例》——7.5 技巧:使用日历微件选择日期