2016年1月1日

Freezing Your Tuples Off 之 vacuum_freeze_min_age

摘要： The vacuum_freeze_min_age setting determines the youngest XID which will be changed to FrozenXID on data pages which are being vacuumed anyway. The ad 阅读全文

posted @ 2016-01-01 19:34 Still water run deep 阅读(517) 评论(0) 推荐(0) 编辑

Understanding virtualxid && transactionid

摘要： 对pg_locks视图中的virtualxid和transactionid字段感到困惑，经查阅资料，特此在此整理一下学习内容：pg_locksColumnsNameTypeReferencesDescriptionlocktypetextType of the lockable object:rel... 阅读全文

posted @ 2016-01-01 18:14 Still water run deep 阅读(731) 评论(0) 推荐(0) 编辑

导航