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. In a high-write workload, which of the following settings would help reduce the I/O impact of checkpoints? Increase checkpoint_timeout Decrease wal_buffers Increase wal_keep_segments Decrease max_wal_size None 1 out of 20 2. Which of the following actions can help reduce WAL generation in a high-write environment? Set wal_level to 'logical' Use unlogged tables for non-critical data Increase checkpoint_timeout Enable full_page_writes 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!
