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_buffers max_wal_size wal_keep_segments checkpoint_timeout None Show Hint The max_wal_size parameter defines the maximum size of WAL files that can be kept, indirectly controlling the number of WAL files. 2. What is a potential risk of setting wal_keep_segments too low in a streaming replication setup? Increased disk usage on the primary server Increased frequency of checkpoints Higher CPU usage on the replica Replication lag due to insufficient WAL segments None Show Hint If wal_keep_segments is set too low, the replica might not be able to catch up if it falls behind, leading to replication lag or even failure. Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Click Submit to see your final score! Previous Start Quiz Next Time's up
