Skip to content

Documentation

PostgreSQL + Redis Performance Audit

Database performance benchmarks with trend analysis and competitive context.

7/4/2026
11 min read Edit on GitHub
Note

Competitive comparisons based on publicly available documentation as of June 2026. All SveltyCMS metrics self-measured via bun test tests/benchmarks/.

Important

Console-only by default. Use BENCHMARK_RECORD=1 to write results to this report.

BENCHMARK_RECORD=1 bun test tests/benchmarks/auth-performance.test.ts

The full matrix runner (bun run scripts/benchmark-matrix/index.ts --sql) always records.

📊 Latest Performance Audit

📝 Fix Overlays

Note

Phase notes and remediation entries appear here after matrix or surgical runs.

⏳ Pending — run full matrix to populate executive summary.

Current Run Summary

Only tests that ran in THIS invocation. Populated after BENCHMARK_RECORD=1 or matrix run.

Historical Trends

Sparklines only — link to history.sqlite for full run tables.

🔬 Full benchmark ledger (41 modules)

Expand dimension groups, then any row, for ASCII truth tables. Executive summary above shows pass/fail and issues only.

Core · 10 tests
🏷️ API LAYER LATENCY · ⏳ pending · ➡️ baseline · source

⏳ Pending — Measures the base network and HTTP overhead for the simplest possible API calls.

🏷️ PHASED COLD START · ⏳ pending · ➡️ baseline · source

⏳ Pending — Measures the time to READY state (serving traffic) vs WARMED state (background tasks).

🏷️ SRE TRUTH AUDIT · ⏳ pending · ➡️ baseline · source

⏳ Pending — The definitive truth audit: SDK vs Dispatcher vs Real HTTP (Production Standalone).

🏷️ Incremental Content Reload · ⏳ pending · ➡️ baseline · source

⏳ Pending — Measures surgical single-file fullReload vs full reconciliation + SCHEMA cache wipe.

🏷️ Middleware & Hooks Performance · ⏳ pending · ➡️ baseline · source

⏳ Pending — High-resolution micro-benchmarks (µs) for individual middleware layers.

🏷️ State Machine Transitions · ⏳ pending · ➡️ baseline · source

⏳ Pending — Validates rapid IDLE -> READY self-healing cycles.

🏷️ Database Adapter Raw CRUD · ⏳ pending · ➡️ baseline · source

⏳ Pending — Direct low-level benchmarks of Create, Read, Update, Delete on the current database adapter.

🏷️ ACID Transaction Overhead · ⏳ pending · ➡️ baseline · source

⏳ Pending — Measures commit/rollback latency and transaction isolation performance.

🏷️ System Cache Efficiency · ⏳ pending · ➡️ baseline · source

⏳ Pending — Audits the performance gain of the 2-layer Hybrid Cache across various system modules.

🏷️ Cache Hit/Miss Ratio & Efficiency · ⏳ pending · ➡️ baseline · source

⏳ Pending — Measures Redis cache hit/miss ratio, cold vs warm read speedup, and invalidation performance.

API · 8 tests
🏷️ Temporal Integrity Audit · ⏳ pending · ➡️ baseline · source

⏳ Pending — Verifies timezone normalization and deterministic UTC persistence.

🏷️ Relational & Nested Queries · ⏳ pending · ➡️ baseline · source

⏳ Pending — Stress-tests JOINs, population strategies, and deeply nested relationships (depth 2–3).

🏷️ Auth & RBAC Performance · ⏳ pending · ➡️ baseline · source

⏳ Pending — Measures JWT verification, session retrieval, and permission matrix resolution overhead.

🏷️ REST API Performance · ⏳ pending · ➡️ baseline · source

⏳ Pending — End-to-end throughput and latency of the unified REST dispatcher.

🏷️ GraphQL API Performance · ⏳ pending · ➡️ baseline · source

⏳ Pending — Resolver execution time and throughput for common queries.

🏷️ Enterprise SEO Suite Audit · ⏳ pending · ➡️ baseline · source

⏳ Pending — E2E audit of Redirect Middleware, 404 Logging, and Sitemap Caching performance.

🏷️ REAL-TIME BROADCAST AUDIT · ⏳ pending · ➡️ baseline · source

⏳ Pending — Benchmarks network-layer broadcast latency (SSE vs WebSocket).

🏷️ WebSocket & Realtime Latency · ⏳ pending · ➡️ baseline · source

⏳ Pending — Benchmarks WebSocket connection/broadcast latency.

Scale · 18 tests
🏷️ Negative Cache Performance · ⏳ pending · ➡️ baseline · source

⏳ Pending — Benchmarks 404-miss response times and cache lookup speedup.

🏷️ Revision & History Growth · ⏳ pending · ➡️ baseline · source

⏳ Pending — Benchmarks performance degradation as document history grows to 100+ versions.

🏷️ Memory Stability & GC Behavior · ⏳ pending · ➡️ baseline · source

⏳ Pending — Long-running soak test to identify memory leaks and GC pressure.

🏷️ Multi-Tenant Performance & Isolation · ⏳ pending · ➡️ baseline · source

⏳ Pending — Stress-tests cross-tenant isolation and security boundary latency.

🏷️ Realistic Mixed Workload · ⏳ pending · ➡️ baseline · source

⏳ Pending — Production request mix: 60% Reads, 20% Writes, 15% GraphQL, 5% Media.

🏷️ GraphQL Load Stress · ⏳ pending · ➡️ baseline · source

⏳ Pending — High-concurrency GraphQL query stress test for resolver efficiency.

🏷️ Bulk Migration & Scale · ⏳ pending · ➡️ baseline · source

⏳ Pending — Measures system ingestion limits and read performance on 10,000+ entries.

🏷️ Million-Row Index Pressure · ⏳ pending · ➡️ baseline · source

⏳ Pending — Measures complex filtering and sorting performance on 100,000+ entry collections.

🏷️ Content Scale Stress · ⏳ pending · ➡️ baseline · source

⏳ Pending — Measures content scan performance on 1,000+ collections under .compiledCollections/test/stress (isolated).

🏷️ Media Upload Stress & Throughput · ⏳ pending · ➡️ baseline · source

⏳ Pending — Measures large file upload throughput, concurrent upload handling, and streaming efficiency.

🏷️ Full Client Journey Simulation · ⏳ pending · ➡️ baseline · source

⏳ Pending — E2E journey: Login -> List -> View -> Edit -> Save -> Realtime. Measures cumulative latency.

🏷️ Concurrency & Race Condition · ⏳ pending · ➡️ baseline · source

⏳ Pending — Verifies atomic consistency and lost-update protection.

🏷️ Multi-Doc Concurrency Throughput · ⏳ pending · ➡️ baseline · source

⏳ Pending — Measures throughput scaling across 10, 100, 1000 documents.

🏷️ Max Throughput — No Throttle · ⏳ pending · ➡️ baseline · source

⏳ Pending — 1000 concurrent writes across 100 docs — no semaphore.

🏷️ Local SDK Throughput · ⏳ pending · ➡️ baseline · source

⏳ Pending — 1000 direct adapter calls — no HTTP, no middleware.

🏷️ Failure Propagation & Fast-Fail Audit · ⏳ pending · ➡️ baseline · source

⏳ Pending — Measures system overhead when downstream dependencies (DB/Redis) fail or timeout.

🏷️ Chaos & Infrastructure Resilience · ⏳ pending · ➡️ baseline · source

⏳ Pending — Simulates 500ms database brownouts and measures CMS availability and stability.

🏷️ Production Day Simulation · ⏳ pending · ➡️ baseline · source

⏳ Pending — Full production day with mixed workload, 100% reliability.

Resilience · 5 tests
🏷️ Circuit Breaker Failover · ⏳ pending · ➡️ baseline · source

⏳ Pending — Measures system graceful degradation when external services fail.

🏷️ Throttling & Backoff Stress · ⏳ pending · ➡️ baseline · source

⏳ Pending — Measures rate-limiting consistency under 10x design load.

🏷️ GDPR Compliance Speed · ⏳ pending · ➡️ baseline · source

⏳ Pending — Measures performance of deep-deletion across all linked tables.

🏷️ Data Residency & Sovereignty · ⏳ pending · ➡️ baseline · source

⏳ Pending — PII blocking and data sovereignty enforcement with cross-region failover.

🏷️ Database Failover & Reconnection · ⏳ pending · ➡️ baseline · source

⏳ Pending — Simulates DB disconnect mid-request — measures circuit breaker activation and reconnection timing.

⏳ Host environment populates after matrix run.

benchmarkperformancepostgresql
Was this page helpful?