On 9/6/16 2:08 PM, Scott Marlowe wrote:
checkpoint_completion_target = 0.9
Too high of a checkpoint completion target may cause buffers to get
written out more often than needed. but it varies based on load etc.
The odds on that don't seem to be terribly high. Even if that is a
common occurrence if it's enough to make a difference then you're
already close to the limits of your IO, and if that's true then you
definitely want to spread the checkpoint out over a longer interval.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532) mobile: 512-569-9461
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
