Re: Disk latency goes up during certaing pediods

From: bricklen <bricklen(at)gmail(dot)com>
To: German Becker <german(dot)becker(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Disk latency goes up during certaing pediods
Date: 2013-07-29 21:07:56
Message-ID: CAGrpgQ8KZO21RRbp7mRVAoCj75NDtuF0+neqOBdUHr=KWhp9Lg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, Jul 29, 2013 at 1:28 PM, German Becker <german(dot)becker(at)gmail(dot)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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Manish Kediyal 2013-07-30 04:41:22 Re: Shell Script for Vacuum
Previous Message German Becker 2013-07-29 20:28:47 Re: Disk latency goes up during certaing pediods