--- title: GitHub - malisper/pgrust: Postgres rewritten in Rust,... description: pgrust is a Postgres rewrite in Rust that now passes 100% of Postgres regression tests, covering over 46,000 queries. It targets compatibility with Postgres... canonical: https://daily.dev/posts/github---malisper-pgrust-postgres-rewritten-in-rust-now-passing-100-of-the-postgres-regression-te-t4anp8pcl twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: GitHub - malisper/pgrust: Postgres rewritten in Rust, now passing 100% of the Postgres regression tests | daily.dev og:description: pgrust is a Postgres rewrite in Rust that now passes 100% of Postgres regression tests, covering over 46,000 queries. It targets compatibility with Postgres... og:url: https://daily.dev/posts/github---malisper-pgrust-postgres-rewritten-in-rust-now-passing-100-of-the-postgres-regression-te-t4anp8pcl og:image: https://api.daily.dev/og/posts/T4Anp8pCl.png og:image:alt: GitHub - malisper/pgrust: Postgres rewritten in Rust, now passing 100% of the Postgres regression tests og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # GitHub - malisper/pgrust: Postgres rewritten in Rust, now passing 100% of the Postgres regression tests **[Hacker News](https://daily.dev/sources/hn)** · 3 min read · 4 upvotes · 0 comments ## Summary pgrust is a Postgres rewrite in Rust that now passes 100% of Postgres regression tests, covering over 46,000 queries. It targets compatibility with Postgres 18.3, is disk-compatible with existing Postgres data directories, and can be tried via a WebAssembly browser demo or Docker. The project is not yet production-ready or performance-optimized, but its roadmap includes multithreaded internals, built-in connection pooling, no-vacuum storage designs, and runtime guardrails for AI-generated SQL. The goal is to make Postgres internals easier to modify using Rust and AI-assisted programming. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### What is pgrust and how compatible is it with Postgres 18.3? Pgrust is a rewrite of Postgres in Rust that targets compatibility with Postgres 18.3 and passes 100% of the Postgres regression tests, matching expected output across more than 46,000 regression queries. It is disk-compatible with Postgres and can boot directly from an existing Postgres 18.3 data directory, though it is not yet production-ready or performance-optimized. _Track how Rust-based database engines like pgrust mature by following database internals coverage on daily.dev._ ### Does pgrust support Postgres extensions like PL/Python or PL/Perl? No, existing Postgres extensions and procedural language extensions such as PL/Python, PL/Perl, and PL/Tcl are not generally compatible with pgrust yet. Some bundled contrib modules have already been ported, and broader extension compatibility may be added over time as the project develops. _Developers evaluating experimental Postgres rewrites can follow compatibility updates on daily.dev._ ### What new database features is pgrust trying to build that standard Postgres lacks? Pgrust aims to add multithreaded Postgres internals, built-in connection pooling, better JSON-heavy workload support, fast forking and branching workflows, storage experiments including no-vacuum designs, runtime guardrails against bad queries and AI-generated SQL, and fewer sudden bad query plan switches. These are exploratory goals enabled by rewriting the server in Rust with AI-assisted development. _Anyone weighing Postgres against emerging forks can keep up with these storage and concurrency experiments on daily.dev._ ## Similar posts on daily.dev - [GitHub - pgcentralfoundation/pgrx: Build Postgres Extensions with Rust\!](https://daily.dev/posts/github---pgcentralfoundation-pgrx-build-postgres-extensions-with-rust--gzoihklhh) · Hacker News · 0 upvotes · 0 comments --- Tags: [#database](https://daily.dev/tags/database), [#rust](https://daily.dev/tags/rust), [#postgresql](https://daily.dev/tags/postgresql), [#ai-coding](https://daily.dev/tags/ai-coding) [View this post on daily.dev](https://daily.dev/posts/github---malisper-pgrust-postgres-rewritten-in-rust-now-passing-100-of-the-postgres-regression-te-t4anp8pcl) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"GitHub - malisper/pgrust: Postgres rewritten in Rust, now passing 100% of the Postgres regression tests","url":"https://daily.dev/posts/github---malisper-pgrust-postgres-rewritten-in-rust-now-passing-100-of-the-postgres-regression-te-t4anp8pcl","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/github---malisper-pgrust-postgres-rewritten-in-rust-now-passing-100-of-the-postgres-regression-te-t4anp8pcl"},"datePublished":"2026-07-09T08:51:54.235Z","dateModified":"2026-09-14T09:26:50.664Z","description":"pgrust is a Postgres rewrite in Rust that now passes 100% of Postgres regression tests, covering over 46,000 queries. It targets compatibility with Postgres...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/cb5d9bcc474632a7a9cced0ca7d202c7?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/cb5d9bcc474632a7a9cced0ca7d202c7?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"Hacker News","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Hacker News","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/hn","url":"https://daily.dev/sources/hn"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/github---malisper-pgrust-postgres-rewritten-in-rust-now-passing-100-of-the-postgres-regression-te-t4anp8pcl","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":4},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"database,rust,postgresql,ai-coding","timeRequired":"PT3M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Hacker News","item":"https://daily.dev/sources/hn"},{"@type":"ListItem","position":3,"name":"GitHub - malisper/pgrust: Postgres rewritten in Rust, now passing 100% of the Postgres regression tests"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/github---malisper-pgrust-postgres-rewritten-in-rust-now-passing-100-of-the-postgres-regression-te-t4anp8pcl#faq","mainEntity":[{"@type":"Question","name":"What is pgrust and how compatible is it with Postgres 18.3?","acceptedAnswer":{"@type":"Answer","text":"Pgrust is a rewrite of Postgres in Rust that targets compatibility with Postgres 18.3 and passes 100% of the Postgres regression tests, matching expected output across more than 46,000 regression queries. It is disk-compatible with Postgres and can boot directly from an existing Postgres 18.3 data directory, though it is not yet production-ready or performance-optimized. Track how Rust-based database engines like pgrust mature by following database internals coverage on daily.dev."}},{"@type":"Question","name":"Does pgrust support Postgres extensions like PL/Python or PL/Perl?","acceptedAnswer":{"@type":"Answer","text":"No, existing Postgres extensions and procedural language extensions such as PL/Python, PL/Perl, and PL/Tcl are not generally compatible with pgrust yet. Some bundled contrib modules have already been ported, and broader extension compatibility may be added over time as the project develops. Developers evaluating experimental Postgres rewrites can follow compatibility updates on daily.dev."}},{"@type":"Question","name":"What new database features is pgrust trying to build that standard Postgres lacks?","acceptedAnswer":{"@type":"Answer","text":"Pgrust aims to add multithreaded Postgres internals, built-in connection pooling, better JSON-heavy workload support, fast forking and branching workflows, storage experiments including no-vacuum designs, runtime guardrails against bad queries and AI-generated SQL, and fewer sudden bad query plan switches. These are exploratory goals enabled by rewriting the server in Rust with AI-assisted development. Anyone weighing Postgres against emerging forks can keep up with these storage and concurrency experiments on daily.dev."}}]} ```