Re: Disk latency goes up during certaing pediods

Поиск

Список

Период

Сортировка

От	bricklen
Тема	Re: Disk latency goes up during certaing pediods
Дата	30 июля 2013 г. 00:08:01
Msg-id	CAGrpgQ8KZO21RRbp7mRVAoCj75NDtuF0+neqOBdUHr=KWhp9Lg@mail.gmail.com обсуждение исходный текст
Ответ на	Re: Disk latency goes up during certaing pediods (German Becker <german.becker@gmail.com>)
Ответы	Re: Disk latency goes up during certaing pediods (German Becker <german.becker@gmail.com>)
Список	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.

В списке pgsql-admin по дате отправления:

От: German Becker
Дата: 29 июля 2013 г., 23:28:52
Сообщение: Re: Disk latency goes up during certaing pediods

От: Manish Kediyal
Дата: 30 июля 2013 г., 07:41:28
Сообщение: Re: Shell Script for Vacuum