pgrust

Postgres rewritten in Rust, now passing 100% of the Postgres regression tests

42 articles 2.5k View on GitHub ↗
42 articles
How Logical and Physical Replication Work in pgrust: A Deep Dive into the CopyBoth API

Explore how pgrust implements logical and physical replication using the CopyBoth API. Discover type-safe Rust methods for seamless data streaming and slot management.

deep-dive
Jul 13, 2026
How pgrust Implements Locking and LWLock: PostgreSQL Concurrency Primitives in Rust

Discover how pgrust implements PostgreSQL locking and LWLock using Rust abstractions. Learn about safe concurrency primitives and RAII guard types for shared memory coordination.

internals
Jul 13, 2026
How pgrust Manages User-Defined Types and Domains: A Deep Dive into the Type Cache System

Discover how pgrust manages user-defined types and domains using a centralized type cache system and specialized modules. Learn about constraint validation and I/O operations.

deep-dive
Jul 13, 2026
How Vacuum and Autovacuum Operations Work in pgrust

Explore how pgrust implements PostgreSQL vacuum and autovacuum in Rust. Understand heap_vacuum_rel, cost-delay, and eager-freeze for efficient database maintenance.

internals
Jul 13, 2026
Connection Handling and Postmaster Architecture in pgrust: A Deep Dive into the Rust PostgreSQL Implementation

Explore pgrust's connection handling and postmaster architecture, a Rust port of PostgreSQL's model. Understand how the master process manages backends for client requests.

deep-dive
Jul 13, 2026
How pgrust Handles Prepared Statements and Portals: PostgreSQL's Two-Stage Model in Rust

Learn how pgrust implements PostgreSQL's prepared statements and portals in Rust. Discover safe Rust seams for query planning and execution contexts.

internals
Jul 13, 2026
How the COPY Command Works in pgrust: Protocol Implementation and Data Streaming

Explore the pgrust COPY command's protocol implementation and data streaming. Understand frontend/backend message handling and PostgreSQL's bulk data transfer.

internals
Jul 13, 2026
Which Index Access Methods Are Supported by pgrust? B‑tree, Hash, GiST, and GIN

Explore pgrust's support for PostgreSQL index access methods including B-tree, Hash, GiST, and GIN. Discover Rust-based equivalents for efficient indexing.

deep-dive
Jul 13, 2026
How pgrust Implements Transaction and Concurrency Control: A Deep Dive into the Rust PostgreSQL Clone

Explore how pgrust implements transaction and concurrency control using safe Rust abstractions and callback-driven seams for MVCC snapshot handling and resource management in this PostgreSQL clone.

deep-dive
Jul 13, 2026
How the pgrust Query Optimizer Works: A Deep Dive into the Rust Implementation

Explore the pgrust query optimizer, a Rust re-implementation of PostgreSQL's planner. Learn its stages: variable flattening, catalog lookups, path generation, and join ordering. Understand this modular architecture.

deep-dive
Jul 13, 2026
pgrust Parser Architecture: How SQL Parsing Works in the PL/pgSQL Frontend

Explore pgrust's parser architecture. Discover how it parses SQL within PL/pgSQL by using a recursive-descent parser and custom scanner, mirroring PostgreSQL's grammar.

architecture
Jul 13, 2026
How the Catalog System Functions in the pgrust Project: A Technical Deep Dive

Explore the pgrust catalog system's Rust implementation of PostgreSQL's system-catalog. Learn about OID lookups, MVCC snapshot management, and runtime catalog-driven dispatch.

deep-dive
Jul 13, 2026

Have a question about this repo?

These articles cover the highlights, but your codebase questions are specific. Give your agent direct access to the source. Share this with your agent to get started:

Share the following with your agent to get started:
curl -s "https://instagit.com/install.md"

Works with
Claude Codex Cursor VS Code OpenClaw Any MCP Client

Maintain an open-source project? Get it listed too →