5x perf increase on writes with FPW disabled in Postgres

· systems databases · Source ↗

TLDR

  • Neon’s lakebase architecture eliminates Postgres Full Page Writes by pushing image generation to distributed storage, achieving 4.5x write throughput gains and 94% WAL reduction.

Key Takeaways

  • Disabling FPW on stateless compute removes torn-page risk; a Paxos-based safekeeper quorum replaces local disk durability.
  • Image generation pushdown to the pageserver keeps delta chains bounded, preserving read performance without compute-side full page images.
  • 32 vCPU benchmark: 95k to 439k NOPM (4.5x); average WAL per transaction drops from 58KB to under 4KB.
  • Production 56 vCPU instance: steady-state WAL fell from 30 MB/s to 1 MB/s; p99 read latency down 30-50%.
  • Synced Tables customer saw row ingestion jump from 17k to 62k rows/sec (3x) after enabling image pushdown.

Hacker News Comment Review

  • No substantive HN discussion yet.

Notable Comments

  • @nikita: Databricks VP and former Neon CEO, offering to answer performance or architecture questions directly.

Original | Discuss on HN