checkpoints, proper config

From: Tory M Blue <tmblue(at)gmail(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: checkpoints, proper config
Date: 2015-12-10 09:12:19
Message-ID: CAEaSS0af0GpqQYSwePKRQq6RtX-x9NXDm=jOXcbcGAmGHXapFw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Joshua D. Drake 2015-12-10 17:20:59 Re: checkpoints, proper config
Previous Message Peter Geoghegan 2015-12-08 06:40:21 Re: Slow Index Creation, why is it not consuming more memory.