把 SQLite -wal 檔正確解析成 frame 與 commit 邊界的驗證記錄，並揭露官方文件在 salt、checksum、checkpoint 時機等關鍵處的錯誤
PostgreSQL 效能調校實戰：從高 CPU、高記憶體到慢查詢的排查
Posted on
Edited on
In
PostgreSQL
,
Performance-Tuning
Disqus:
Symbols count in article: 16k Reading time ≈ 15 mins.
Symbols count in article: 16k Reading time ≈ 15 mins.
一套可實作的 PostgreSQL 效能排查：用 wait event、pg_stat_statements、EXPLAIN 由上而下定位高 CPU、高記憶體、慢查詢、鎖等待與表膨脹問題，每個症狀都附上可直接執行的 SQL。
深入 pgrx 呼叫慣例：一個 Rust 值如何進出 PostgreSQL
Posted on
Edited on
In
Rust
,
PostgreSQL
,
pgrx
Disqus:
Symbols count in article: 11k Reading time ≈ 10 mins.
Symbols count in article: 11k Reading time ≈ 10 mins.
用一個最簡單的 #[pg_extern] 函式當主角，追到 pgrx 最底層的 ABI trait，把 Rust 型別與 PostgreSQL Datum 之間的完整轉換機制講清楚。
深入 PostgreSQL 變長度資料儲存：Varlena 與 TOAST 機制完整解析
Posted on
Edited on
In
PostgreSQL
,
SystemDesign
Disqus:
Symbols count in article: 9.8k Reading time ≈ 9 mins.
Symbols count in article: 9.8k Reading time ≈ 9 mins.
從 Varlena 三種 header 格式到 TOAST 切塊、compression、B-Tree 索引、storage strategy 與 detoast 流程,完整拆解 PostgreSQL 如何優雅地塞下 1GB 大欄位
深入 pgrx 機制：用 Rust 撰寫 PostgreSQL Extension 的底層原理與實戰
Posted on
Edited on
In
Rust
,
PostgreSQL
,
pgrx
Disqus:
Symbols count in article: 18k Reading time ≈ 16 mins.
Symbols count in article: 18k Reading time ≈ 16 mins.
從零開始拆解 pgrx 如何讓 Rust 與 C 寫的 PostgreSQL 完美互通,並以 timescale-extension-utils-rs 為例,帶初學者了解 pg_fn!、pg_agg!、Datum 轉換、MemoryContext 與 longjmp 處理的完整機制
pg_dbmigrator: Near-Zero-Downtime PostgreSQL Migration with Online Mode
Posted on
Edited on
In
Rust
,
PostgreSQL
,
logical-replication
Disqus:
Symbols count in article: 15k Reading time ≈ 14 mins.
Symbols count in article: 15k Reading time ≈ 14 mins.
A hands-on guide to pg_dbmigrator, a Rust CLI for migrating PostgreSQL databases — covering offline dump/restore and the online logical-replication mode for near-zero-downtime cutovers.
pg_pidstat: Real-Time Per-Backend CPU, Memory, and I/O Monitoring for PostgreSQL
Posted on
Edited on
In
Rust
,
PostgreSQL
,
Monitoring
Disqus:
Symbols count in article: 7.6k Reading time ≈ 7 mins.
Symbols count in article: 7.6k Reading time ≈ 7 mins.
pg_pidstat is a Rust-based PostgreSQL extension that adds real-time per-backend CPU, memory, I/O, and context switch monitoring via a single SQL view.
pg-walstream: High-Performance PostgreSQL WAL Streaming in Rust
Posted on
Edited on
In
Rust
,
PostgreSQL
,
logical-replication
Disqus:
Symbols count in article: 14k Reading time ≈ 12 mins.
Symbols count in article: 14k Reading time ≈ 12 mins.
A high-performance Rust library for parsing and streaming PostgreSQL WAL messages via logical replication — with load testing results showing 200K+ events/sec.
pg2any: A Rust CDC Library for Streaming PostgreSQL Changes to Any Database
Posted on
Edited on
In
Rust
,
PostgreSQL
,
logical-replication
Disqus:
Symbols count in article: 7.9k Reading time ≈ 7 mins.
Symbols count in article: 7.9k Reading time ≈ 7 mins.
pg2any is a Rust CDC library that streams PostgreSQL changes via logical replication to MySQL, SQL Server, or SQLite with crash-safe persistence
【開源介紹】redis_fdw_rs：讓 PostgreSQL 直接查 Redis 的 FDW 擴充套件（Rust 編寫）
Posted on
Edited on
In
Rust
,
PostgreSQL
,
Redis
,
FDW
Disqus:
Symbols count in article: 3.6k Reading time ≈ 3 mins.
Symbols count in article: 3.6k Reading time ≈ 3 mins.
介紹開源專案 redis_fdw_rs，使用 Rust 與 pgrx 實作的 Redis FDW，讓 PostgreSQL 直接查詢 Redis 資料如同操作一般資料表