Frequent checkpoints cause performance spikes during write-heavy workloads

Default checkpoint settings cause frequent checkpoint operations that create sudden bursts of disk writes, leading to performance hiccups during write-heavy workloads.

Spread checkpoint disk writes over time by configuring: checkpoint_timeout = 15min and max_wal_size = 2GB in postgresql.conf. This prevents sudden performance spikes by distributing writes more evenly. Requires PostgreSQL restart to apply.