Still waters run deep

摘要： I’ll demonstrate how to relocate a tablespace directory without the reconstruction of databases. I have a tablespace tblspc located at /home/postgres/ 阅读全文

摘要： Among the many things to say about logical replication features added in PostgreSQL 9.4, REPLICA IDENTITY is a new table-level parameter that can be u 阅读全文

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

摘要： 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 阅读全文

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

摘要： Thebucardoproject has released itsnagios plugins for PostgreSQLand we can extract from them this nice view in order to check for table and indexbloati... 阅读全文

摘要： Update:Heikki’s slides arehere!Heikki Linnakangas gave a presentation this past Sunday atFOSDEMabout the improved free space map (FSM), which tracks u... 阅读全文

摘要： Introduction------------The Heap Only Tuple (HOT) feature eliminates redundant index entries andallows the re-use of space taken by DELETEd or obsolet... 阅读全文

摘要： Checkpoints can be a major drag on write-heavy PostgreSQL installations. The first step toward identifying issues in this area is to monitor how oft... 阅读全文

摘要： 在PG的众多参数中，参数checkpoint相关的几个参数颇为神秘。这些参数与checkpoint的调度有关，对系统的稳定性还是比较重要的，下面我们为大家解析一下，这要先从PG的数据同步机制谈起。PG的数据同步机制众所周知，数据库的后台进程在执行用户事务时，发生的数据更改是先写入缓冲池中，对应PG就... 阅读全文