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.