Re: Strange checkpoint behavior - checkpoints take a longtime

From: Andres Freund <andres(at)anarazel(dot)de>
To: Vladimir Nicolici <vladnc(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Strange checkpoint behavior - checkpoints take a longtime
Date: 2017-10-06 03:03:29
Message-ID: 20171006030329.emrm24hvf2si6kv3@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

On 2017-10-06 05:53:39 +0300, Vladimir Nicolici wrote:
> Hello, it’s postgres 9.6.

Consider setting checkpoint_flush_after to 16MB or something large like that.

> I will probably try the compression on Monday or Tuesday, I can only
> experiment with a single set of changes in a day, and I plan to test
> something else tomorrow.
>
> Thanks for the suggestions, and sorry for the reply style, but my mail
> client is not best suited for replying inline to individual points.

You should consider getting a new mail client then...

- Andres

In response to

Browse pgsql-general by date

  From Date Subject
Next Message vinny 2017-10-06 07:07:36 Re: delete a file everytime pg server starts/crashes
Previous Message Vladimir Nicolici 2017-10-06 02:53:39 Re: Strange checkpoint behavior - checkpoints take a longtime