PostgreSQL Internals

A real UUID v4 collision on HackerNews sparked 479 upvotes and 347 comments. Combined with UUID v4 vs v7 performance benchmarks on PG 16, here's how to choose.

Starting from the collation mismatch exception, this article dives deep into PostgreSQL collation version management and the principles of operating system libc dependencies.

A horizontal comparison of logical replication architectures and their pros and cons across Oracle, MySQL, and PostgreSQL, with an in-depth evaluation of each database's replication philosophy.

Starting from a query conflict on a static table, this article dives deep into the root causes of standby query conflicts in PostgreSQL and the principles behind XLOG_HEAP2_CLEAN.

A summary of common PostgreSQL DDL change pitfalls and clever workarounds — a quick-reference cheat sheet.

Deep dive into advanced Linux memory management topics, covering buddy allocator, page tables & TLB, reverse mapping, and NUMA architecture principles.

An in-depth analysis of PostgreSQL CLOG file structure and transaction status storage principles, including transaction ID location and standby synchronization mechanisms.

An in-depth analysis of PostgreSQL streaming replication principles and process architecture, covering synchronous and asynchronous modes and failover switchover mechanisms.

A detailed explanation of PostgreSQL logical replication mechanisms, covering logical decoding, replication slots, output plugins, and publish/subscribe architecture.

Explaining vector database core concepts from the ground up, covering embeddings, RAG (Retrieval-Augmented Generation), and LLM fundamentals.