摘要：The quick summary of this issue is that the backup_label file is an integral part of your database cluster binary backup, and removing it to allow the 阅读全文

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

摘要：TL;DR: Don't ever setfsync=off, don'tkill -9the postmaster then deletepostmaster.pid, don't run PostgreSQL on network file systems.Reports of database... 阅读全文

摘要：Naoya:Hi,hackers!I have a question about txid_current().it is "Why does txid_current() assign new transaction-id?".When we executes txid_current() out... 阅读全文

摘要：Q:I have been trying to make our database clients pro-active about not filling up the partition on which the database they are using resides.As all ou... 阅读全文

摘要：“时间线”（Timeline）是PG一个很有特色的概念，在备份恢复方面的文档里面时有出现。但针对这个概念的详细解释却很少，也让人不太好理解，我们在此仔细解析一下。时间线的引入为了理解引入时间线的背景，我们来分析一下，如果没有时间线，会有什么问题？先举个将数据库恢复到以前时间点的例子。假设在一个数据库... 阅读全文

摘要：Including csvlog in the log_destination list provides a convenient way to import log files into a database table. This option emits log lines in comma... 阅读全文

摘要：After loooong pause, adding next (well, second) post to the “series“. This time, I'd like to describe how logging works. And I don't mean binary loggi... 阅读全文

摘要：While there are somedocson it, I decided to write about it, in perhaps more accessible language – not as a developer, but as PostgreSQL user.Some part... 阅读全文

摘要：问题出现我们在线上巡检中发现，一个实例的pg_xlog目录，增长到4G，很是疑惑。刚开始怀疑是日志归档过慢，日志堆积在pg_xlog目录下面，未被清除导致。于是检查归档目录下的文件，内容如下。但发现新近完成写入的日志文件都被归档成功了（即在pg_xlog/archive_status里面，有对应的x... 阅读全文

摘要：Guillaume Lelarge:Hi,As part of our monitoring work for our customers, we stumbled upon an issue with our customers' servers who have a wal_keep_segme... 阅读全文