Skip to content

PGRAC v0.131.0 — optimized stable MVP

Choose a tag to compare

View all tags
@sqlrush sqlrush released this 20 Sep 06:17
v0.131.0
83d8c5a

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
Assets 4
Loading