Still waters run deep

摘要： Starting new blog series – explanation of various configuration parameters. I will of course follow no schedule or order – if I'd had to – it would... 阅读全文

摘要： Q:Dear Support Team,If we use ubuntu server to install postgresql9.4, how can we keep original data to downgrade postgresql from 9.4 to 9.3. Would it ... 阅读全文

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