PASSIVE checkpoints may not fully checkpoint when writers are active. TRUNCATE mode blocks writers briefly but ensures complete checkpointing, keeping the WAL small for consistent read performance under heavy load.
PASSIVE checkpoints may not fully checkpoint when writers are active. TRUNCATE mode blocks writers briefly but ensures complete checkpointing, keeping the WAL small for consistent read performance under heavy load.