blog_xqhx

KO | EN

gitlite — search

#hacktoberfest #ai #llm #deep-learning #linux #macos #nodejs #windows #awesome #cli #kubernetes #security #pytorch #ios

(★ 78)

小桥河西的博客

blog_xqhx Latest Version Download

Download Latest Version (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# 小桥河西的博客

## 博文一览
- [2025-09-14:配置vscode 远程debug linux下的PostgreSQL进程](https://github.com/ChenHuajun/blog_xqhx/blob/main/2025/2025-09-14-%E9%85%8D%E7%BD%AEvscode%20%E8%BF%9C%E7%A8%8Bdebug%20linux%E4%B8%8B%E7%9A%84PostgreSQL%E8%BF%9B%E7%A8%8B.md)
- [2023-07-16:PostgreSQL分页查询排序字段不唯一会导致结果重复和丢失](https://github.com/ChenHuajun/blog_xqhx/blob/main/2023/2023-07-16-PostgreSQL%E5%88%86%E9%A1%B5%E6%9F%A5%E8%AF%A2%E6%8E%92%E5%BA%8F%E5%AD%97%E6%AE%B5%E4%B8%8D%E5%94%AF%E4%B8%80%E4%BC%9A%E5%AF%BC%E8%87%B4%E7%BB%93%E6%9E%9C%E9%87%8D%E5%A4%8D%E5%92%8C%E4%B8%A2%E5%A4%B1.md)
- [2023-07-16:如何查看PostgreSQL的执行计划](https://github.com/ChenHuajun/blog_xqhx/blob/main/2023/2023-07-16-%E5%A6%82%E4%BD%95%E6%9F%A5%E7%9C%8BPostgreSQL%E7%9A%84%E6%89%A7%E8%A1%8C%E8%AE%A1%E5%88%92.md)
- [2022-10-22:关于Count-Min Sketch在数据库基数估算中的应用](https://github.com/ChenHuajun/blog_xqhx/blob/main/2022/2022-10-22-%E5%85%B3%E4%BA%8ECount-Min%20Sketch%E5%9C%A8%E6%95%B0%E6%8D%AE%E5%BA%93%E5%9F%BA%E6%95%B0%E4%BC%B0%E7%AE%97%E4%B8%AD%E7%9A%84%E5%BA%94%E7%94%A8.md)
- [2022-09-22:PostgreSQL统计信息的持久化](https://github.com/ChenHuajun/blog_xqhx/blob/main/2022/2022-09-22-PostgreSQL%E7%BB%9F%E8%AE%A1%E4%BF%A1%E6%81%AF%E7%9A%84%E6%8C%81%E4%B9%85%E5%8C%96.md)
- [2022-09-17:深分页慢查询优化](https://github.com/ChenHuajun/blog_xqhx/blob/main/2022/2022-09-17-%E6%B7%B1%E5%88%86%E9%A1%B5%E6%85%A2%E6%9F%A5%E8%AF%A2%E4%BC%98%E5%8C%96.md)
- [2022-09-09:PostgreSQL生成JOIN SQL执行计划时间过长](https://github.com/ChenHuajun/blog_xqhx/blob/main/2022/2022-09-09-PostgreSQL%E7%94%9F%E6%88%90JOIN%20SQL%E6%89%A7%E8%A1%8C%E8%AE%A1%E5%88%92%E6%97%B6%E9%97%B4%E8%BF%87%E9%95%BF.md)
- [2022-09-07:PostgreSQL中的孤儿数据文件](https://github.com/ChenHuajun/blog_xqhx/blob/main/2022/2022-09-07-PostgreSQL%E4%B8%AD%E7%9A%84%E5%AD%A4%E5%84%BF%E6%95%B0%E6%8D%AE%E6%96%87%E4%BB%B6.md)
- [2022-09-05:PostgreSQL表锁的获取过程](https://github.com/ChenHuajun/blog_xqhx/blob/main/2022/2022-09-05-PostgreSQL%E8%A1%A8%E9%94%81%E7%9A%84%E8%8E%B7%E5%8F%96%E8%BF%87%E7%A8%8B.md)
- [2022-09-02:PostgreSQL Merge Join在特定场景下估算值偏小](https://github.com/ChenHuajun/blog_xqhx/blob/main/2022/2022-09-02-PostgreSQL%20Merge%20Join%E5%9C%A8%E7%89%B9%E5%AE%9A%E5%9C%BA%E6%99%AF%E4%B8%8B%E4%BC%B0%E7%AE%97%E5%80%BC%E5%81%8F%E5%B0%8F.md)
- [2022-08-30:PostgreSQL有时为什么不走索引而选择cost更高的全表扫描](https://github.com/ChenHuajun/blog_xqhx/blob/main/2022/2022-08-30-PostgreSQL%E6%9C%89%E6%97%B6%E4%B8%BA%E4%BB%80%E4%B9%88%E4%B8%8D%E8%B5%B0%E7%B4%A2%E5%BC%95%E8%80%8C%E9%80%89%E6%8B%A9cost%E6%9B%B4%E9%AB%98%E7%9A%84%E5%85%A8%E8%A1%A8%E6%89%AB%E6%8F%8F.md)
- [2022-08-27:PostgreSQL where条件的in列表中超过100个值导致不走索引](https://github.com/ChenHuajun/blog_xqhx/blob/main/2022/2022-08-27-PostgreSQL%20where%E6%9D%A1%E4%BB%B6%E7%9A%84in%E5%88%97%E8%A1%A8%E4%B8%AD%E8%B6%85%E8%BF%87100%E4%B8%AA%E5%80%BC%E5%AF%BC%E8%87%B4%E4%B8%8D%E8%B5%B0%E7%B4%A2%E5%BC%95.md)
- [2022-08-21:PostgreSQL同步复制可能导致主库滞后异步备库或逻辑订阅端](https://github.com/ChenHuajun/blog_xqhx/blob/main/2022/2022-08-21-PostgreSQL%E5%90%8C%E6%AD%A5%E5%A4%8D%E5%88%B6%E5%8F%AF%E8%83%BD%E5%AF%BC%E8%87%B4%E4%B8%BB%E5%BA%93%E6%BB%9E%E5%90%8E%E5%BC%82%E6%AD%A5%E5%A4%87%E5%BA%93%E6%88%96%E9%80%BB%E8%BE%91%E8%AE%A2%E9%98%85%E7%AB%AF.md)
- [2022-08-18:为什么PostgreSQL不支持分区全局索引](https://github.com/ChenHuajun/blog_xqhx/blob/main/2022/2022-08-18-%E4%B8%BA%E4%BB%80%E4%B9%88PostgreSQL%E4%B8%8D%E6%94%AF%E6%8C%81%E5%88%86%E5%8C%BA%E5%85%A8%E5%B1%80%E7%B4%A2%E5%BC%95.md)
- [2022-08-07:关于PostgreSQL增量Checkpoint](https://github.com/ChenHuajun/blog_xqhx/blob/main/2022/2022-08-07-%E5%85%B3%E4%BA%8EPostgreSQL%E5%A2%9E%E9%87%8FCheckpoint.md)
- [2022-07-13:PG12分区表聚合查询导致OOM](https://github.com/ChenHuajun/blog_xqhx/blob/main/2022/2022-07-13-PG12%E5%88%86%E5%8C%BA%E8%A1%A8%E8%81%9A%E5%90%88%E6%9F%A5%E8%AF%A2%E5%AF%BC%E8%87%B4OOM.md)
- [2022-06-12:关于pgcompacttable](https://github.com/ChenHuajun/blog_xqhx/blob/main/2022/2022-06-12-%E5%85%B3%E4%BA%8Epgcompacttable.md)
- [2022-05-11:PostgreSQL部分实用SQL](https://github.com/ChenHuajun/blog_xqhx/blob/main/2022/2022-05-11-PostgreSQL%E9%83%A8%E5%88%86%E5%AE%9E%E7%94%A8SQL.md)
- [2022-04-23:PostgreSQL按字节长度截断字符串](https://github.com/ChenHuajun/blog_xqhx/blob/main/2022/2022-04-23-PostgreSQL%E6%8C%89%E5%AD%97%E8%8A%82%E9%95%BF%E5%BA%A6%E6%88%AA%E6%96%AD%E5%AD%97%E7%AC%A6%E4%B8%B2.md)
- [2022-04-23:PostgreSQL表和索引膨胀检查](https://github.com/ChenHuajun/blog_xqhx/blob/main/2022/2022-04-23-PostgreSQL%E8%A1%A8%E5%92%8C%E7%B4%A2%E5%BC%95%E8%86%A8%E8%83%80%E6%A3%80%E6%9F%A5.md)
- [2022-03-30:openGauss和PostgreSQL的差异](https://github.com/ChenHuajun/blog_xqhx/blob/main/2022/2022-03-30-openGauss%E5%92%8CPostgreSQL%E7%9A%84%E5%B7%AE%E5%BC%82.md)
- [2022-02-17:PostgreSQL代码小知识CATALOG_VARLEN宏定义](https://github.com/ChenHuajun/blog_xqhx/blob/main/2022/2022-02-17-PostgreSQL%E4%BB%A3%E7%A0%81%E5%B0%8F%E7%9F%A5%E8%AF%86CATALOG_VARLEN%E5%AE%8F%E5%AE%9A%E4%B9%89.md)
- [2021-12-26:PostgreSQL执行计划走偏常见案例之一LIMIT查询](https://github.com/ChenHuajun/blog_xqhx/blob/main/2021/2021-12-26-PostgreSQL%E6%89%A7%E8%A1%8C%E8%AE%A1%E5%88%92%E8%B5%B0%E5%81%8F%E5%B8%B8%E8%A7%81%E6%A1%88%E4%BE%8B%E4%B9%8B%E4%B8%80LIMIT%E6%9F%A5%E8%AF%A2.md)
- [2021-08-17:PostgreSQL全表扫描大表会不会把已经加载到共享缓存的页面全部驱逐](https://github.com/ChenHuajun/blog_xqhx/blob/main/2021/2021-08-17-PostgreSQL%E5%85%A8%E8%A1%A8%E6%89%AB%E6%8F%8F%E5%A4%A7%E8%A1%A8%E4%BC%9A%E4%B8%8D%E4%BC%9A%E6%8A%8A%E5%B7%B2%E7%BB%8F%E5%8A%A0%E8%BD%BD%E5%88%B0%E5%85%B1%E4%BA%AB%E7%BC%93%E5%AD%98%E7%9A%84%E9%A1%B5%E9%9D%A2%E5%85%A8%E9%83%A8%E9%A9%B1%E9%80%90.md)
- [2021-08-14:PostgreSQL为什么有时候用主键查询不走主键索引](https://github.com/ChenHuajun/blog_xqhx/blob/main/2021/2021-08-14-PostgreSQL%E4%B8%BA%E4%BB%80%E4%B9%88%E6%9C%89%E6%97%B6%E5%80%99%E7%94%A8%E4%B8%BB%E9%94%AE%E6%9F%A5%E8%AF%A2%E4%B8%8D%E8%B5%B0%E4%B8%BB%E9%94%AE%E7%B4%A2%E5%BC%95.md)
- [2021-07-25:autovacuum_vacuum_cost_limit参数调优](https://github.com/ChenHuajun/blog_xqhx/blob/main/2021/2021-07-25-autovacuum_vacuum_cost_limit%E5%8F%82%E6%95%B0%E8%B0%83%E4%BC%98.md)
- [2021-05-09:PostgreSQL中实现单双字符的模糊匹配](https://github.com/ChenHuajun/blog_xqhx/blob/main/2021/2021-05-09-PostgreSQL%E4%B8%AD%E5%AE%9E%E7%8E%B0%E5%8D%95%E5%8F%8C%E5%AD%97%E7%AC%A6%E7%9A%84%E6%A8%A1%E7%B3%8A%E5%8C%B9%E9%85%8D.md)
- [2021-04-29:PostgreSQL对象的依赖关系解析](https://github.com/ChenHuajun/blog_xqhx/blob/main/2021/2021-04-29-PostgreSQL%E5%AF%B9%E8%B1%A1%E7%9A%84%E4%BE%9D%E8%B5%96%E5%85%B3%E7%B3%BB%E8%A7%A3%E6%9E%90.md)
- [2021-03-07:并行插入导致Page压缩数据文件空间分配出现不连续](https://github.com/ChenHuajun/blog_xqhx/blob/main/2021/2021-03-07-%E5%B9%B6%E8%A1%8C%E6%8F%92%E5%85%A5%E5%AF%BC%E8%87%B4Page%E5%8E%8B%E7%BC%A9%E6%95%B0%E6%8D%AE%E6%96%87%E4%BB%B6%E7%A9%BA%E9%97%B4%E5%88%86%E9%85%8D%E5%87%BA%E7%8E%B0%E4%B8%8D%E8%BF%9E%E7%BB%AD.md)
- [2021-01-01:PostgreSQL执行计划走偏常见案例之二多Join条件组合](https://github.com/ChenHuajun/blog_xqhx/blob/main/2022/2021-01-01-PostgreSQL%E6%89%A7%E8%A1%8C%E8%AE%A1%E5%88%92%E8%B5%B0%E5%81%8F%E5%B8%B8%E8%A7%81%E6%A1%88%E4%BE%8B%E4%B9%8B%E4%BA%8C%E5%A4%9AJoin%E6%9D%A1%E4%BB%B6%E7%BB%84%E5%90%88.md)
- [2020-11-11:Citus大量数据导出优化](https://github.com/ChenHuajun/blog_xqhx/blob/main/2020/2020-11-11-Citus%E5%A4%A7%E9%87%8F%E6%95%B0%E6%8D%AE%E5%AF%BC%E5%87%BA%E4%BC%98%E5%8C%96.md)
- [2020-11-11:关于etcd事件捕获的断点重续](https://github.com/ChenHuajun/blog_xqhx/blob/main/2020/2020-11-11-%E5%85%B3%E4%BA%8Eetcd%E4%BA%8B%E4%BB%B6%E6%8D%95%E8%8E%B7%E7%9A%84%E6%96%AD%E7%82%B9%E9%87%8D%E7%BB%AD.md)
- [2020-09-07:基于Patroni的Citus高可用环境部署](https://github.com/ChenHuajun/blog_xqhx/blob/main/2020/2020-09-07-%E5%9F%BA%E4%BA%8EPatroni%E7%9A%84Citus%E9%AB%98%E5%8F%AF%E7%94%A8%E7%8E%AF%E5%A2%83%E9%83%A8%E7%BD%B2.md)
- [2020-09-07:基于Patroni的PostgreSQL高可用环境部署](https://github.com/ChenHuajun/blog_xqhx/blob/main/2020/2020-09-07-%E5%9F%BA%E4%BA%8EPatroni%E7%9A%84PostgreSQL%E9%AB%98%E5%8F%AF%E7%94%A8%E7%8E%AF%E5%A2%83%E9%83%A8%E7%BD%B2.md)
- [2020-08-04:pg_rewind实现原理简单分析](https://github.com/ChenHuajun/blog_xqhx/blob/main/2020/2020-08-04-pg_rewind%E5%AE%9E%E7%8E%B0%E5%8E%9F%E7%90%86%E7%AE%80%E5%8D%95%E5%88%86%E6%9E%90.md)
- [2020-07-05:Citus7.4-Citus 9.3新特性](https://github.com/ChenHuajun/blog_xqhx/blob/main/2020/2020-07-05-Citus7.4-Citus%209.3%E6%96%B0%E7%89%B9%E6%80%A7.md)
- [2020-07-05:再谈Citus 多CN部署与Citus MX](https://github.com/ChenHuajun/blog_xqhx/blob/main/2020/2020-07-05-%E5%86%8D%E8%B0%88Citus%20%E5%A4%9ACN%E9%83%A8%E7%BD%B2%E4%B8%8ECitus%20MX.md)
- [2020-05-08:关于PG逻辑订阅判断数据是否同步的方法](https://github.com/ChenHuajun/blog_xqhx/blob/main/2020/2020-05-08-%E5%85%B3%E4%BA%8EPG%E9%80%BB%E8%BE%91%E8%AE%A2%E9%98%85%E5%88%A4%E6%96%AD%E6%95%B0%E6%8D%AE%E6%98%AF%E5%90%A6%E5%90%8C%E6%AD%A5%E7%9A%84%E6%96%B9%E6%B3%95.md)
- [2020-04-26:PostgreSQL求解最短路径](https://github.com/ChenHuajun/blog_xqhx/blob/main/2020/2020-04-26-PostgreSQL%E6%B1%82%E8%A7%A3%E6%9C%80%E7%9F%AD%E8%B7%AF%E5%BE%84.md)
- [2020-04-26:关于PostgreSQL逻辑订阅中的复制状态](https://github.com/ChenHuajun/blog_xqhx/blob/main/2020/2020-04-26-%E5%85%B3%E4%BA%8EPostgreSQL%E9%80%BB%E8%BE%91%E8%AE%A2%E9%98%85%E4%B8%AD%E7%9A%84%E5%A4%8D%E5%88%B6%E7%8A%B6%E6%80%81.md)
- [2020-04-14:zedstore开发版初体验](https://github.com/ChenHuajun/blog_xqhx/blob/main/2020/2020-04-14-zedstore%E5%BC%80%E5%8F%91%E7%89%88%E5%88%9D%E4%BD%93%E9%AA%8C.md)
- [2020-04-12:timesacledb列压缩能否作为冷数据存储方案](https://github.com/ChenHuajun/blog_xqhx/blob/main/2020/2020-04-12-timesacledb%E5%88%97%E5%8E%8B%E7%BC%A9%E8%83%BD%E5%90%A6%E4%BD%9C%E4%B8%BA%E5%86%B7%E6%95%B0%E6%8D%AE%E5%AD%98%E5%82%A8%E6%96%B9%E6%A1%88.md)
- [2020-04-04:PostgreSQL WAL解析与闪回的一些想法](https://github.com/ChenHuajun/blog_xqhx/blob/main/2020/2020-04-04-PostgreSQL%20WAL%E8%A7%A3%E6%9E%90%E4%B8%8E%E9%97%AA%E5%9B%9E%E7%9A%84%E4%B8%80%E4%BA%9B%E6%83%B3%E6%B3%95.md)
- [2020-04-03:如何在PostgreSQL故障切换后找回丢失的数据](https://github.com/ChenHuajun/blog_xqhx/blob/main/2020/2020-04-03-%E5%A6%82%E4%BD%95%E5%9C%A8PostgreSQL%E6%95%85%E9%9A%9C%E5%88%87%E6%8D%A2%E5%90%8E%E6%89%BE%E5%9B%9E%E4%B8%A2%E5%A4%B1%E7%9A%84%E6%95%B0%E6%8D%AE.md)
- [2020-03-19:MySQL对无主键表的复制](https://github.com/ChenHuajun/blog_xqhx/blob/main/2020/2020-03-19-MySQL%E5%AF%B9%E6%97%A0%E4%B8%BB%E9%94%AE%E8%A1%A8%E7%9A%84%E5%A4%8D%E5%88%B6.md)
- [2020-01-05:修改PostgreSQL字段长度导致cached plan must not change result type错误](https://github.com/ChenHuajun/blog_xqhx/blob/main/2020/2020-01-05-%E4%BF%AE%E6%94%B9PostgreSQL%E5%AD%97%E6%AE%B5%E9%95%BF%E5%BA%A6%E5%AF%BC%E8%87%B4cached%20plan%20must%20not%20change%20result%20type%E9%94%99%E8%AF%AF.md)
- [2019-08-25:ip地址段查询深度优化案例详解](https://github.com/ChenHuajun/blog_xqhx/blob/main/2019/2019-08-25-ip%E5%9C%B0%E5%9D%80%E6%AE%B5%E6%9F%A5%E8%AF%A2%E6%B7%B1%E5%BA%A6%E4%BC%98%E5%8C%96%E6%A1%88%E4%BE%8B%E8%AF%A6%E8%A7%A3.md)
- [2018-11-25:PostgreSQL bug 15290并行索引扫描导致连接hang](https://github.com/ChenHuajun/blog_xqhx/blob/main/2018/2018-11-25-PostgreSQL%20bug%2015290%E5%B9%B6%E8%A1%8C%E7%B4%A2%E5%BC%95%E6%89%AB%E6%8F%8F%E5%AF%BC%E8%87%B4%E8%BF%9E%E6%8E%A5hang.md)
- [2018-10-04:关于citus.limit_clause_row_fetch_count优化参数](https://github.com/ChenHuajun/blog_xqhx/blob/main/2018/2018-10-04-%E5%85%B3%E4%BA%8Ecitus.limit_clause_row_fetch_count%E4%BC%98%E5%8C%96%E5%8F%82%E6%95%B0.md)
- [2018-10-04:多CN citus发行命令记录](https://github.com/ChenHuajun/blog_xqhx/blob/main/2018/2018-10-04-%E5%A4%9ACN%20citus%E5%8F%91%E8%A1%8C%E5%91%BD%E4%BB%A4%E8%AE%B0%E5%BD%95.md)
- [2018-07-30:PostgreSQL逻辑复制源使用示例](https://github.com/ChenHuajun/blog_xqhx/blob/main/2018/2018-07-30-PostgreSQL%E9%80%BB%E8%BE%91%E5%A4%8D%E5%88%B6%E6%BA%90%E4%BD%BF%E7%94%A8%E7%A4%BA%E4%BE%8B.md)
- [2018-07-30:PostgreSQL逻辑订阅处理流程解析](https://github.com/ChenHuajun/blog_xqhx/blob/main/2018/2018-07-30-PostgreSQL%E9%80%BB%E8%BE%91%E8%AE%A2%E9%98%85%E5%A4%84%E7%90%86%E6%B5%81%E7%A8%8B%E8%A7%A3%E6%9E%90.md)
- [2018-06-28:PostgreSQL复制断开故障](https://github.com/ChenHuajun/blog_xqhx/blob/main/2018/2018-06-28-PostgreSQL%E5%A4%8D%E5%88%B6%E6%96%AD%E5%BC%80%E6%95%85%E9%9A%9C.md)
- [2018-06-11:citus实战系列之四多CN部署](https://github.com/ChenHuajun/blog_xqhx/blob/main/2018/2018-06-11-citus%E5%AE%9E%E6%88%98%E7%B3%BB%E5%88%97%E4%B9%8B%E5%9B%9B%E5%A4%9ACN%E9%83%A8%E7%BD%B2.md)
- [2018-06-10:citus实战系列之三平滑扩容](https://github.com/ChenHuajun/blog_xqhx/blob/main/2018/2018-06-10-citus%E5%AE%9E%E6%88%98%E7%B3%BB%E5%88%97%E4%B9%8B%E4%B8%89%E5%B9%B3%E6%BB%91%E6%89%A9%E5%AE%B9.md)
- [2018-05-21:citus实战系列之二实验环境搭建](https://github.com/ChenHuajun/blog_xqhx/blob/main/2018/2018-05-21-citus%E5%AE%9E%E6%88%98%E7%B3%BB%E5%88%97%E4%B9%8B%E4%BA%8C%E5%AE%9E%E9%AA%8C%E7%8E%AF%E5%A2%83%E6%90%AD%E5%BB%BA.md)
- [2018-05-18:citus实战系列之一入门篇](https://github.com/ChenHuajun/blog_xqhx/blob/main/2018/2018-05-18-citus%E5%AE%9E%E6%88%98%E7%B3%BB%E5%88%97%E4%B9%8B%E4%B8%80%E5%85%A5%E9%97%A8%E7%AF%87.md)
- [2018-05-06:zone_reclaim_mode引发PostgreSQL sys CPU利用率飙升](https://github.com/ChenHuajun/blog_xqhx/blob/main/2018/2018-05-06-zone_reclaim_mode%E5%BC%95%E5%8F%91PostgreSQL%20sys%20CPU%E5%88%A9%E7%94%A8%E7%8E%87%E9%A3%99%E5%8D%87.md)
- [2018-03-04:citus平滑扩容和缩容](https://github.com/ChenHuajun/blog_xqhx/blob/main/2018/2018-03-04-citus%E5%B9%B3%E6%BB%91%E6%89%A9%E5%AE%B9%E5%92%8C%E7%BC%A9%E5%AE%B9.md)
- [2018-03-04:使用Docker搭建citus实验环境](https://github.com/ChenHuajun/blog_xqhx/blob/main/2018/2018-03-04-%E4%BD%BF%E7%94%A8Docker%E6%90%AD%E5%BB%BAcitus%E5%AE%9E%E9%AA%8C%E7%8E%AF%E5%A2%83.md)
- [2017-12-31:闲聊PostgreSQL的oid](https://github.com/ChenHuajun/blog_xqhx/blob/main/2017/2017-12-31-%E9%97%B2%E8%81%8APostgreSQL%E7%9A%84oid.md)
- [2017-12-24:如何利用pg_resetwal回到过去](https://github.com/ChenHuajun/blog_xqhx/blob/main/2017/2017-12-24-%E5%A6%82%E4%BD%95%E5%88%A9%E7%94%A8pg_resetwal%E5%9B%9E%E5%88%B0%E8%BF%87%E5%8E%BB.md)
- [2017-12-22:唯一索引的行估算实验](https://github.com/ChenHuajun/blog_xqhx/blob/main/2017/2017-12-22-%E5%94%AF%E4%B8%80%E7%B4%A2%E5%BC%95%E7%9A%84%E8%A1%8C%E4%BC%B0%E7%AE%97%E5%AE%9E%E9%AA%8C.md)
- [2017-10-10:MySQL Utilities 高可用工具体验](https://github.com/ChenHuajun/blog_xqhx/blob/main/2017/2017-10-10-MySQL%20Utilities%20%E9%AB%98%E5%8F%AF%E7%94%A8%E5%B7%A5%E5%85%B7%E4%BD%93%E9%AA%8C.md)
- [2017-09-25:一次PostgreSQL行估算偏差导致的慢查询分析](https://github.com/ChenHuajun/blog_xqhx/blob/main/2017/2017-09-25-%E4%B8%80%E6%AC%A1PostgreSQL%E8%A1%8C%E4%BC%B0%E7%AE%97%E5%81%8F%E5%B7%AE%E5%AF%BC%E8%87%B4%E7%9A%84%E6%85%A2%E6%9F%A5%E8%AF%A2%E5%88%86%E6%9E%90.md)
- [2017-09-12:PostgreSQL字符类型长度变更的性能](https://github.com/ChenHuajun/blog_xqhx/blob/main/2017/2017-09-12-PostgreSQL%E5%AD%97%E7%AC%A6%E7%B1%BB%E5%9E%8B%E9%95%BF%E5%BA%A6%E5%8F%98%E6%9B%B4%E7%9A%84%E6%80%A7%E8%83%BD.md)
- [2017-09-02:PostgreSQL如何保障数据的一致性](https://github.com/ChenHuajun/blog_xqhx/blob/main/2017/2017-09-02-PostgreSQL%E5%A6%82%E4%BD%95%E4%BF%9D%E9%9A%9C%E6%95%B0%E6%8D%AE%E7%9A%84%E4%B8%80%E8%87%B4%E6%80%A7.md)
- [2017-08-15:PostgreSQL的表膨胀及对策](https://github.com/ChenHuajun/blog_xqhx/blob/main/2017/2017-08-15-PostgreSQL%E7%9A%84%E8%A1%A8%E8%86%A8%E8%83%80%E5%8F%8A%E5%AF%B9%E7%AD%96.md)
- [2017-06-10:如何遏制PostgreSQL WAL的疯狂增长](https://github.com/ChenHuajun/blog_xqhx/blob/main/2017/2017-06-10-%E5%A6%82%E4%BD%95%E9%81%8F%E5%88%B6PostgreSQL%20WAL%E7%9A%84%E7%96%AF%E7%8B%82%E5%A2%9E%E9%95%BF.md)
- [2017-01-17:基于Pacemaker的PostgreSQL一主多从读负载均衡集群搭建](https://github.com/ChenHuajun/blog_xqhx/blob/main/2017/2017-01-17-%E5%9F%BA%E4%BA%8EPacemaker%E7%9A%84PostgreSQL%E4%B8%80%E4%B8%BB%E5%A4%9A%E4%BB%8E%E8%AF%BB%E8%B4%9F%E8%BD%BD%E5%9D%87%E8%A1%A1%E9%9B%86%E7%BE%A4%E6%90%AD%E5%BB%BA.md)
- [2017-01-17:基于Pacemkaer Resource Agent的LVS负载均衡](https://github.com/ChenHuajun/blog_xqhx/blob/main/2017/2017-01-17-%E5%9F%BA%E4%BA%8EPacemkaer%20Resource%20Agent%E7%9A%84LVS%E8%B4%9F%E8%BD%BD%E5%9D%87%E8%A1%A1.md)
- [2016-11-30:关于MySQL的GTID和crash safe](https://github.com/ChenHuajun/blog_xqhx/blob/main/2016/2016-11-30-%E5%85%B3%E4%BA%8EMySQL%E7%9A%84GTID%E5%92%8Ccrash%20safe.md)
- [2016-11-09:MySQL和PostgreSQL的比较](https://github.com/ChenHuajun/blog_xqhx/blob/main/2016/2016-11-09-MySQL%E5%92%8CPostgreSQL%E7%9A%84%E6%AF%94%E8%BE%83.md)
- [2016-08-14:iptables防火墙设置示例](https://github.com/ChenHuajun/blog_xqhx/blob/main/2016/2016-08-14-iptables%E9%98%B2%E7%81%AB%E5%A2%99%E8%AE%BE%E7%BD%AE%E7%A4%BA%E4%BE%8B.md)
- [2016-08-14:初步理解MySQL的隔离级别和gap锁](https://github.com/ChenHuajun/blog_xqhx/blob/main/2016/2016-08-14-%E5%88%9D%E6%AD%A5%E7%90%86%E8%A7%A3MySQL%E7%9A%84%E9%9A%94%E7%A6%BB%E7%BA%A7%E5%88%AB%E5%92%8Cgap%E9%94%81.md)
- [2016-05-20:互联网经济下遇见更好的开源数据库](https://github.com/ChenHuajun/blog_xqhx/blob/main/2016/2016-05-20-%E4%BA%92%E8%81%94%E7%BD%91%E7%BB%8F%E6%B5%8E%E4%B8%8B%E9%81%87%E8%A7%81%E6%9B%B4%E5%A5%BD%E7%9A%84%E5%BC%80%E6%BA%90%E6%95%B0%E6%8D%AE%E5%BA%93.md)
- [2015-07-30:安全相关的几个网站](https://github.com/ChenHuajun/blog_xqhx/blob/main/2015/2015-07-30-%E5%AE%89%E5%85%A8%E7%9B%B8%E5%85%B3%E7%9A%84%E5%87%A0%E4%B8%AA%E7%BD%91%E7%AB%99.md)
- [2015-07-17:关于PostgreSQL流复制的延迟](https://github.com/ChenHuajun/blog_xqhx/blob/main/2015/2015-07-17-%E5%85%B3%E4%BA%8EPostgreSQL%E6%B5%81%E5%A4%8D%E5%88%B6%E7%9A%84%E5%BB%B6%E8%BF%9F.md)
- [2015-07-01:PostgreSQL中的full_page_writes的理解](https://github.com/ChenHuajun/blog_xqhx/blob/main/2015/2015-07-01-PostgreSQL%E4%B8%AD%E7%9A%84full_page_writes%E7%9A%84%E7%90%86%E8%A7%A3.md)
- [2015-06-29:《Next generation of GIN》解读](https://github.com/ChenHuajun/blog_xqhx/blob/main/2015/2015-06-29-%E3%80%8ANext%20generation%20of%20GIN%E3%80%8B%E8%A7%A3%E8%AF%BB.md)
- [2015-06-27:btree-gin用于范围查询的奇怪现象](https://github.com/ChenHuajun/blog_xqhx/blob/main/2015/2015-06-27-btree-gin%E7%94%A8%E4%BA%8E%E8%8C%83%E5%9B%B4%E6%9F%A5%E8%AF%A2%E7%9A%84%E5%A5%87%E6%80%AA%E7%8E%B0%E8%B1%A1.md)
- [2015-06-27:关于gin的部分匹配](https://github.com/ChenHuajun/blog_xqhx/blob/main/2015/2015-06-27-%E5%85%B3%E4%BA%8Egin%E7%9A%84%E9%83%A8%E5%88%86%E5%8C%B9%E9%85%8D.md)
- [2014-10-01:利用openjade+ctex+jadetex从sgml生成PostgreSQL中文pdf手册](https://github.com/ChenHuajun/blog_xqhx/blob/main/2014/2014-10-01-%E5%88%A9%E7%94%A8openjade%2Bctex%2Bjadetex%E4%BB%8Esgml%E7%94%9F%E6%88%90PostgreSQL%E4%B8%AD%E6%96%87pdf%E6%89%8B%E5%86%8C.md)
- [2013-11-21:关于docbook sgml的中文字符支持](https://github.com/ChenHuajun/blog_xqhx/blob/main/2013/2013-11-21-%E5%85%B3%E4%BA%8Edocbook%20sgml%E7%9A%84%E4%B8%AD%E6%96%87%E5%AD%97%E7%AC%A6%E6%94%AF%E6%8C%81.md)

blog_xqhx

blog_xqhx Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

blog_xqhx

blog_xqhx Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

Download README