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

Reply via email to