PG优质资料整理

整体：

 

德哥：从Oracle DBA到PostgreSQL布道者https://yq.aliyun.com/articles/60153

 

流式复制：

PostgreSQL 10 新特性, 流式接收端在线压缩redo https://yq.aliyun.com/articles/69278?spm=a2c4e.11163080.searchblog.168.65842ec1aysMn1

PostgreSQL的streaming replication https://yq.aliyun.com/articles/356727?spm=a2c4e.11163080.searchblog.89.5b372ec1IpGlTY

异步流复制模式如何保证不丢数据? https://yq.aliyun.com/articles/78029?spm=a2c4e.11163080.searchblog.17.6cc92ec1WyhiRa

PGPool-II+PG流复制实现HA主备切换 https://yq.aliyun.com/articles/636817?spm=a2c4e.11163080.searchblog.101.5b372ec1IpGlTY

PostgreSQL - 鱼与熊掌可兼得 - 多副本0丢失与高性能兼得 - 事务级异步、同步开关 https://yq.aliyun.com/articles/280454?spm=a2c4e.11163080.searchblog.111.5b372ec1IpGlTY

PostgreSQL 流复制协议交互式调试 - replication=true https://yq.aliyun.com/articles/640707?spm=a2c4e.11163080.searchblog.123.25152ec1cjrlOv

xlog:

如何遏制PostgreSQL WAL的疯狂增长 https://mp.weixin.qq.com/s/k4Uda7_uB9q99ZnYYGkD-w?spm=a2c4e.11153940.blogcont608913.13.5e171082zDBE6g

PgSQL · 特性分析 · Write-Ahead Logging机制浅析 http://mysql.taobao.org/monthly/2017/03/02/

pg_resetxlog整理及测试  https://yq.aliyun.com/articles/55691?spm=a2c4e.11163080.searchblog.87.1f442ec1psrFTF

pg_resetxlog清理的pg_xlog下的WAL日志 https://yq.aliyun.com/articles/504754?spm=a2c4e.11163080.searchblog.49.5b372ec1ceiQQP

PostgreSQL的xlog实验一 https://yq.aliyun.com/articles/357517?spm=a2c4e.11163080.searchblog.133.5b372ec1IpGlTY

恢复：

PostgreSQL PITR实验 https://yq.aliyun.com/articles/357513?spm=a2c4e.11163080.searchblog.9.5b372ec1ceiQQP

初步认识pg_control文件之一 https://yq.aliyun.com/articles/357600?spm=a2c4e.11163080.searchblog.9.6cc92ec1WyhiRa

PostgreSQL flashback(闪回) 功能实现与介绍 https://yq.aliyun.com/articles/228267?spm=a2c4e.11163080.searchblog.121.6cc92ec1WyhiRa

PostgreSQL Master Slave升级过程 https://yq.aliyun.com/articles/509552?spm=a2c4e.11163080.searchblog.123.5b372ec1IpGlTY

PgSQL · 最佳实践 · pg_rman源码浅析与使用 https://yq.aliyun.com/articles/71929?spm=a2c4e.11163080.searchblog.141.6cc92ec1WyhiRa

PostgreSQL flashback(闪回) 功能实现与介绍 https://yq.aliyun.com/articles/228267?spm=a2c4e.11163080.searchblog.121.6cc92ec1WyhiRa

PgSQL · 特性分析 · 数据库崩溃恢复（上）http://mysql.taobao.org/monthly/2017/05/03/?spm=a2c4e.11153940.blogcont608913.9.5e1710829piRwu

PostgreSQL数据库如何从崩溃中恢复（下） https://yq.aliyun.com/articles/608913?spm=a2c4e.11163080.searchblog.221.48d92ec1N8m00m

 

checkpoint

PgSQL · 特性分析 · checkpoint机制浅析 http://mysql.taobao.org/monthly/2017/04/04/

测试：

向bgwriter 发送 SIGQUIT 的实验 https://yq.aliyun.com/articles/360080?spm=a2c4e.11163080.searchblog.70.5b372ec1IpGlTY

PostreSQL崩溃试验全记录 https://yq.aliyun.com/articles/356912?spm=a2c4e.11163080.searchblog.80.5b372ec1IpGlTY

使用

不要滥用UNLOGGED table 和 hash index https://yq.aliyun.com/articles/576647?spm=a2c4e.11163080.searchblog.74.6cc92ec1WyhiRa

PostgreSQL AWR报告 https://yq.aliyun.com/articles/64873?spm=a2c4e.11163080.searchblog.44.6cc92ec1WyhiRa

PostgreSQL DaaS设计注意 - schema与database的抉择 https://yq.aliyun.com/articles/61574?spm=a2c4e.11163080.searchblog.93.1f442ec1psrFTF

PostgreSQL HOT STANDBY using Stream replication  https://yq.aliyun.com/articles/14712?spm=a2c4e.11163080.searchblog.120.1f442ec1psrFTF

使用pg_resetxlog修复PostgreSQL控制文件的方法 https://yq.aliyun.com/articles/59113?spm=a2c4e.11163080.searchblog.69.54632ec1WmhGiL

工具：

PgSQL · 特性分析 · 逻辑导出pg_dump分析 https://yq.aliyun.com/articles/608917?spm=a2c4e.11153940.blogrightarea608913.13.5e1710829piRwu

bugs:

一条SQL引发系统out of memory PostgreSQL https://yq.aliyun.com/articles/504606?spm=a2c4e.11163080.searchblog.154.6cc92ec1WyhiRa

PgSQL · 特性分析 · 事务ID回卷问题  https://yq.aliyun.com/articles/608908?spm=a2c4e.11153940.blogrightarea608913.20.5e1710829piRwu