data/postgres/pg-xpatch/types-and-limitations Reference
Data types & limitations
Which column types work where, and the things pg-xpatch
Not verified yet postgres 16
Postgres
15 results
data/postgres/pg-xpatch/tuning-read-performance How-to
Tuning read performance
Size the content cache to your working set, warm it
Not verified yet postgres 16
data/postgres/pg-xpatch/tuning-compression How-to
Tuning compression & storage
How keyframe_every, compress_depth, and enable_zstd trade storage
Not verified yet postgres 16
data/postgres/pg-xpatch/storage-model Explanation
How storage works
Keyframes, deltas, per-group chains, and how pg-xpatch rebuilds
Not verified yet postgres 16
data/postgres/pg-xpatch/sql-functions Reference
SQL functions
Complete reference for the xpatch.* schema, signatures, arguments, and returned
Not verified yet postgres 16
data/postgres/pg-xpatch/server-parameters Reference
Server parameters
Every pg_xpatch.* GUC, with default, range, change context, and
Not verified yet postgres 16
data/postgres/pg-xpatch/quickstart Tutorial
Quickstart: your first versioned table
Build a tiny document store with pg-xpatch, from an
Not verified yet postgres 16
data/postgres/pg-xpatch/overview Explanation
What pg-xpatch is
A PostgreSQL table access method that stores versioned rows as
Not verified yet postgres 16
data/postgres/pg-xpatch/monitoring How-to
Monitoring & introspection
The functions that answer is compression working, is the cache
Not verified yet postgres 16
data/postgres/pg-xpatch/installation How-to
Installing pg-xpatch
Install pg-xpatch on PostgreSQL 16 with Docker, a prebuilt
Not verified yet postgres 16
data/postgres/pg-xpatch/example-notes-app Tutorial
Example: a versioned notes app
A real Svelte app where every keystroke is a version
Not verified yet postgres 16
data/postgres/pg-xpatch/configuration How-to
Configuring a table
When auto-detection is enough, when to call xpatch.configure(), and
Not verified yet postgres 16
data/postgres/pg-xpatch/caching-and-performance Explanation
Caching & performance
Why pg-xpatch keeps a shared-memory cache, what lives
Not verified yet postgres 16
data/postgres/pg-xpatch/benchmarks Explanation
Benchmarks
What pg-xpatch's compression and speed look like in
Not verified yet postgres 16
data/postgres/pg-xpatch/backup-and-restore How-to
Backup & restore
pg_dump and pg_restore work with xpatch tables, with
Not verified yet postgres 16