01 2016 档案

Streaming replication slots in PostgreSQL 9.4
摘要：Streaming replication slots are a pending feature in PostgreSQL 9.4, as part ofthe logical changeset extractionfeature.What are they for, what do you ... 阅读全文

posted @ 2016-01-18 01:34 Still water run deep 阅读(310) 评论(0) 推荐(0)

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 阅读(539) 评论(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 阅读(814) 评论(0) 推荐(0)

导航