Write Ahead Logging (WAL) & Checkpointing Quiz Home › PostgreSQL DBA › Write Ahead Logging (WAL) & Checkpointing 📋 Postgres Database Administration – Write Ahead Logging (WAL) & Checkpointing 20 questions · 15 min timer · Explanations included · Free 1. Which parameter controls the maximum number of WAL files that can be kept in the pg_wal directory? wal_keep_segments max_wal_size checkpoint_timeout wal_buffers None 1 out of 20 2. What is the effect of setting synchronous_commit to 'off'? It ensures all transactions are immediately durable It may lead to data loss in case of a crash It increases the frequency of checkpoints It compresses WAL files None 2 out of 20 Loading questions... 3 out of 20 Loading questions... 4 out of 20 Loading questions... 5 out of 20 Loading questions... 6 out of 20 Loading questions... 7 out of 20 Loading questions... 8 out of 20 Loading questions... 9 out of 20 Loading questions... 10 out of 20 Loading questions... 11 out of 20 Loading questions... 12 out of 20 Loading questions... 13 out of 20 Loading questions... 14 out of 20 Loading questions... 15 out of 20 Loading questions... 16 out of 20 Loading questions... 17 out of 20 Loading questions... 18 out of 20 Loading questions... 19 out of 20 Loading questions... 20 out of 20 Click Submit to see your final score! Previous Start Quiz Next Time's upTime is Up!
