9.3.4 CentOS 256Gb system
total_checkpoints | minutes_between_checkpoints
-------------------+-----------------------------
109943 | 0.0274886580556895
I've just bumped then to 150.
# - Checkpoints -
checkpoint_segments = 150
checkpoint_timeout = 5min
checkpoint_completion_target = 0.9
checkpoint_warning = 3600s
WAL buffers are 32MB
Very intense work loads during the eve, much lighter during the day. I need the help when I attempt to shove a ton of data in the DB
Any suggestions?
Tory
