Skip to content

Releases: sqlrush/pgrac

PGRAC v0.131.0 — optimized stable MVP

Choose a tag to compare

@sqlrush sqlrush released this 20 Sep 06:17

PGRAC v0.131.0 — optimized stable MVP

Stable source release within the existing MVP scope, based on PostgreSQL 16.13.
This release improves undo-header resource locality, includes qualification-time
correctness fixes, and adds opt-in UPDATE latency tracing (disabled by default).

Qualification

  • Formal correctness PRE: 4/4 valid samples, four Linux instances with
    32 clients per instance, 5-second warmup and 35-second measurement.
  • Every sample: zero unexpected client/server errors, no forced cancellation,
    complete ordered byte comparisons of all 1,000,000 rows on every node, and
    passing pre/post health, state-invariant and outstanding-work checks.
  • All four instances then shut down normally. All four native control files
    report shut down; test data is retained. No crash recovery was performed.
  • Original client and launcher return codes remain recorded. The existing
    natural-tail policy accepts timing-only late completion only after all required
    correctness checks pass; no SQL error or forced cancellation is waived.
Formal PRE sample Cluster committed TPS
1 1364.62
2 1167.14
3 1087.36
4 1082.45

Median: 1127.25 TPS. Peak: 1364.62 TPS. The host OS reported battery
operation during this correctness run, so these observations are not a matched
power/thermal performance comparison, a sustained-1200-TPS claim or an Oracle
benchmark result. The lower later rounds are retained, not omitted.

An earlier host-suspend interruption remains a failed attempt. Its data and
logs were preserved; the successful retry used a separate copy of the same
normally stopped cold snapshot, without recovery or re-population.

Performance evidence

A separate controlled, alternating comparison held the correctness fixes and
data constant and changed only undo-header locality. All four comparison runs
passed complete correctness checks and normal shutdown. Candidate runs were
1423.09 / 1391.29 TPS; control runs were 212.86 / 879.03 TPS. The candidate
mean, 1407.19 TPS, was about 60.1% above the faster control run.

The control varied substantially: this is not a confidence interval or a causal
comparison against an unmodified older stable release. The
versioned release notes
retain the complete comparison, mechanism measurements and the separate failed
instrumented control observation. That observation's exact failed sampling
predicate is unproven and is not claimed independently reproduced and fixed.
The candidate instrumented capture passed all required checks.

Immutable source and CI

  • Tagged source: 83d8c5a002643581f153058b7a766afe1ffa1eb0.
  • Main integration: 7081edf0422ae04f1b3dcc28785b9d4d98e724d7, through
    PR #80; its tree equals the tagged
    candidate exactly.
  • Qualified Linux binary SHA-256:
    4cbbc0b87505453b6940e207916b8b975ff93e9cdb49373638d49d41f4ba8550.
    Configure flags: --enable-cluster --enable-tap-tests --without-icu, without
    --enable-cassert. CI separately exercises assertion-enabled builds.
  • Tag-triggered Fast CI
    and MVP release CI
    passed all seven required jobs on the exact tagged source.
  • Main integration CI
    passed all five required Fast jobs on the merge commit.

The attached JSON files contain sanitized qualification results and the final
exact-commit CI evidence. Earlier failures remain visible; only manual CODEOWNER
approval was bypassed under the user's PR-specific authorization. No CI or
correctness check was waived.

Installation and scope

This is a source-only stable MVP, not production HA certification. It does
not certify crash recovery, automatic failover, independent-host shared-LUN/GFS2
deployment, production external fencing, backup restore, general data migration,
full SQL/2PC compatibility or mixed-version/rolling upgrades. Normal restart
evidence is not crash-recovery evidence.

All nodes must shut down normally before a homogeneous binary switch. No
disk-format, wire-format, workload or configured-timeout change is included.
Existing tags remain immutable.

git clone --branch v0.131.0 --single-branch https://github.com/sqlrush/pgrac.git
cd pgrac
cat PGRAC_VERSION

PGRAC v0.130.1 — MVP correctness maintenance

Choose a tag to compare

@sqlrush sqlrush released this 18 Sep 16:11

PGRAC v0.130.1 — MVP correctness maintenance

Maintenance update to v0.130.0, focused on consistent-read completion,
transaction/deadlock waits, update-receipt lifetime, visibility and shared-read
reservation cleanup. No experimental scheduling or worker-isolation performance
changes are included. Existing safety refusals remain enforced.

Qualification

  • Four valid PRE samples, four Linux instances with 32 clients per instance.
  • Zero unexpected client/server errors, no forced cancellation, full ordered
    comparisons of 1,000,000 rows on every node after each sample, and all required
    health, invariant and outstanding-work checks passed.
  • Retained clean data was reused. Final coordinated normal shutdown passed on
    all four nodes, with all control files reporting shut down and data retained.
  • Median recorded TPS: 404.385; peak: 568.54. These are not a controlled
    performance comparison or evidence of improvement. The four individual
    results, including the lower later samples, are preserved in the release notes.
  • Full Fast and MVP release CI passed on the exact tagged commit
    30a86aece4ada5f4ca60d3a8dc794da64b1d7a43. The
    attached JSON records the accepted immutable commit and workflow/job identities.
    Earlier failed attempts remain visible in GitHub Actions; passing an unchanged
    rerun does not establish the root cause of an earlier intermittent failure.

Verified tag-triggered runs:
Fast CI,
MVP release CI.
All seven required jobs executed successfully. The
main integration CI
also passed all five jobs.

Scope

This is a source-only MVP maintenance release, not certification of crash
recovery, automatic failover, independent-host shared-LUN/GFS2 deployment,
production external fencing or mixed-version/rolling upgrades. Clean restart
evidence is not crash-recovery evidence. Existing v0.130.0 stays immutable.

PGRAC v0.130.0 — 首个 MVP 稳定版

Choose a tag to compare

@sqlrush sqlrush released this 17 Sep 08:57

PGRAC v0.130.0 — 首个 MVP 稳定版

PostgreSQL 基线:16.13。发布形式:源码。稳定范围:已验收的 MVP 能力,不代表生产 HA 全面认证。

  • 发布提交通过全部 7 项 MVP CI 检查;精确提交和工作流链接见附件 mvp-ci-evidence.json
  • CI 修复后的同一内核通过四节点 × 每节点 32 客户端的 4 个有效 PRE 正确性样本。
  • 客户端与服务端无意外错误;每轮四节点百万行完整对账、健康及清理/债务检查通过。
  • 保留原数据正常启动与全体正常关机已验证;本次发布只更新版本资料和文档,不修改该内核。
  • 集群 TPS 中位数 558.615,峰值 578.11;性能仅记录,不是发布门或性能承诺。

较前一个预发布快照,发布 CI 欠账已闭合;历史范围外测试及失败记录仍保留,不宣称这些能力已通过。

获取与使用

git clone --branch v0.130.0 --single-branch https://github.com/sqlrush/pgrac.git pgrac-mvp1
cd pgrac-mvp1
cat PGRAC_VERSION
git rev-parse HEAD

附件 pgrac-0.130.0-source.tar.gz 为固定标签的源码包;SHA256SUMS 校验源码包与 CI 证据。GitHub 自动生成的 Source code 下载是另一种封装,不与该固定附件共用哈希。本次不提供签名二进制包。

限制

四台独立主机共享 LUN、GFS2 部署、崩溃/强杀恢复、自动故障接管、外部 fencing 部署、备份恢复、滚动/混合版本升级及完整 SQL/2PC 兼容性尚未获得本次认证。正常关机后重启通过不等于崩溃恢复通过。

旧标签 v0.130.0-mvp.1 保持不可变。v0.130.0 是 MVP 范围内的首个稳定版本;v1.0.0 留给后续完整产品资格化。

PGRAC MVP 1 — v0.130.0-mvp.1

Pre-release

Choose a tag to compare

@sqlrush sqlrush released this 16 Sep 06:36

pgrac v0.130.0-mvp.1 — MVP 1

Author: SqlRush sqlrush@gmail.com

Date: 2026-09-16. Evaluation prerelease; not production certified.

This is the first frozen MVP baseline of pgrac, a shared-disk, multi-active
cluster based on PostgreSQL 16.13. It records the completed four-node
correctness and coordinated normal-restart acceptance scope below.

Validated scope

The same candidate completed the entire sequence, including all data, health
and outstanding-work checks:

Check Result
Four nodes, 16 clients per node Passed; 25,751 commits; no SQL or unexpected server errors
Four nodes, 8 clients per node Passed; 23,587 commits; no SQL or unexpected server errors
Full data comparison after both workloads All four ordered million-row exports matched
Coordinated normal shutdown of all four nodes Passed; clean shutdown completed in 7.95 seconds
Normal startup using the same data Passed; complete data unchanged across shutdown/startup
Another workload, 16 clients per node after restart Passed; 26,989 commits; no SQL or unexpected server errors
Final full data, health and outstanding-work checks All passed

This is evidence for the stated workloads and configuration, not proof that
every SQL feature or failure scenario is supported. Natural completion after
the measurement window was checked separately from SQL and data correctness.

Release identity

  • Tested implementation commit: 9ddd1b81ce070b312497731873c76a7a69ad6f28.
  • Release metadata and documentation do not change the tested implementation.
  • Tested assertion-build SHA-256:
    7af46dacd722e7436808139384481c2631cfc91cce70f074772a66282124fb82.
  • This is a source release. No portable, signed or production-certified binary
    package is supplied by these notes.

The GitHub Actions status belongs to the exact release commit and is separate
from the completed four-node acceptance result above. These notes do not claim
that all historical CI suites or all supported platforms passed.

Known CI limitation: the repository-wide clang-format 18 check currently
reports 401 non-conforming files out of 840 checked. Full CI qualification is
not complete. This MVP is published as a correctness-tested source snapshot,
not as a CI-qualified stable release. No check was disabled and the tested
implementation was not changed to publish this snapshot.

Limitations

  • Use only in a controlled evaluation environment with non-production data.
  • Crash/forced-stop recovery, failover, external-fencing deployment certification,
    backup/restore qualification and rolling upgrades are not certified by this MVP.
  • Normal restart was validated with the same binary, data and configuration;
    it is not evidence for restarting crash-damaged data or upgrading old data.
  • Higher-concurrency qualification and performance acceptance are not included.
    Recorded throughput is not a service-level guarantee.
  • The legacy compiled version string is not synchronized with this release
    label; identify builds by their tag, commit and binary hash.

Getting the source

git clone --branch v0.130.0-mvp.1 --single-branch https://github.com/sqlrush/pgrac.git
cd pgrac
git rev-parse HEAD
cat PGRAC_VERSION

Follow the installation guide and
bootstrap guide. The release number alone does not
assert on-disk or wire compatibility with earlier snapshots. Do not overwrite
an existing installation or data directory to try this release.

See release identification and version policy for tag and rollback
boundaries.