checkpoints, proper config - Mailing list pgsql-performance

 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