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 of the following is a potential downside of having a very high checkpoint_timeout setting? More frequent checkpoints leading to performance degradation Higher risk of data loss in case of a crash Increased CPU usage Increased I/O during checkpoints None 1 out of 20 2. Which parameter controls the maximum number of WAL files that can be kept in the pg_wal directory? max_wal_size wal_buffers wal_keep_segments checkpoint_timeout 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 up
