Still waters run deep

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