What Is PITR (Point-In-Time Recovery)?
Point-in-time recovery (PITR) restores a PostgreSQL database to an exact timestamp by replaying WAL records from a base backup.
Why It Matters for PostgreSQL Performance
In PostgreSQL performance work, PITR readiness is critical for resilience because benchmark and migration experiments can expose rollback needs.
Practical Benchmarking Context
When benchmarking with pgbench, validate recovery runbooks periodically so performance testing does not outpace operational safety.
Use this term together with workload shape, concurrency level, and scale factor when interpreting pgbench outputs. Isolated values can be misleading without full run context.
Example
Example: Recover to 14:37 UTC right before an accidental delete and resume service with minimal data loss.