Home > mailing lists

Re: Disk latency goes up during certaing pediods - Mailing list pgsql-admin

From	bricklen
Subject	Re: Disk latency goes up during certaing pediods
Date	July 30, 2013 00:08:01
Msg-id	CAGrpgQ8KZO21RRbp7mRVAoCj75NDtuF0+neqOBdUHr=KWhp9Lg@mail.gmail.com Whole thread Raw
In response to	Re: Disk latency goes up during certaing pediods (German Becker <german.becker@gmail.com>)
Responses	Re: Disk latency goes up during certaing pediods (German Becker <german.becker@gmail.com>)
List	pgsql-admin

On Mon, Jul 29, 2013 at 1:28 PM, German Becker <german.becker@gmail.com> wrote:

checkpoint_segments = 256 # in logfile segments, min 1, 16MB each

I'm curious about checkpoint_segments. 256 seems pretty high -- did testing show that that helps?

checkpoint_completion_target = 0.7 # checkpoint target duration, 0.0 - 1.0

0.7 could be bumped up to 0.9, but I doubt that that will make a very noticeable difference for this particular issue.

From: German Becker
Date: 29 July 2013, 23:28:52
Subject: Re: Disk latency goes up during certaing pediods

From: Manish Kediyal
Date: 30 July 2013, 07:41:28
Subject: Re: Shell Script for Vacuum