Message-ID: <COL129-W186A40FA6CEAFEE926F3E692000@phx.gbl>
From: Steven Jones <steven.jones1201@outlook.com>
To: "ik@postgresql-consulting.com" <ik@postgresql-consulting.com>
CC: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Subject: Re: Very slow checkpoints
Date: Wed, 18 Mar 2015 12:19:09 +0000
Importance: Normal
In-Reply-To: 
 <CAG95seW1=QHDDaO1Juh7g_Zzg_0-ebCZSgzTUdzKBJ05EVWwgg@mail.gmail.com>
References: <COL129-W88EAA235AC3967FF7F5D8792000@phx.gbl>
 <CAG95seW33nJtZmu+8XDia3kM6zm-aNyQYn3NbSvsm_f7WK-VoQ@mail.gmail.com>,
 <COL129-W41B57411604205109F5AC592000@phx.gbl>,
 <CAG95seW1=QHDDaO1Juh7g_Zzg_0-ebCZSgzTUdzKBJ05EVWwgg@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

Thanks.

Kernel is:=A03.5.0-36-generic #57~precise1-Ubuntu

Also - xlog is on ext4; db partition is zfs (on top of hardware RAID1+0).

Regards,
Steve

----------------------------------------
> From: ilya.kosmodemiansky@postgresql-consulting.com
> Date: Wed, 18 Mar 2015 13:13:36 +0100
> Subject: Re: [PERFORM] Very slow checkpoints
> To: steven.jones1201@outlook.com
> CC: pgsql-performance@postgresql.org
>
> On Wed, Mar 18, 2015 at 12:58 PM, Steven Jones
> <steven.jones1201@outlook.com> wrote:
>> Yes BBU is on the controller; 1024Mb. It is a HP P410i controller, with =
write caching turned on the controller; off on disk level.
>
>
> vm.dirty_background_bytes=3D67108864 and vm.dirty_bytes=3D536870912 looks
> resonable for 512MB BBU, you can calculate them for 1024 or
> recalculate them for dirty_background_ratio
>
> By the way, which kernel do you use?
>
>> We don't at this stage have any graphs, but we will set it up over the n=
ext 24hrs at least.
>
> Do not forget to have iostat statistics on them, at least latency,
> %iowait and %util, such parameters are very helpful.
>
> And I am always suspicious about zfs under heavy writes. It is
> reliable and quite comfortable in terms of configuration, but for
> speed ext4 or xfs with disabled barrier looks more reasonable
>
>>>
>>> --
>>> Ilya Kosmodemiansky,
>>>
>>> PostgreSQL-Consulting.com
>>> tel. +14084142500
>>> cell. +4915144336040
>>> ik@postgresql-consulting.com
>>>
>>>
>>> --
>>> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.o=
rg)
>>> To make changes to your subscription:
>>> http://www.postgresql.org/mailpref/pgsql-performance
>>
>
>
>
> --
> Ilya Kosmodemiansky,
>
> PostgreSQL-Consulting.com
> tel. +14084142500
> cell. +4915144336040
> ik@postgresql-consulting.com
>
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
=20=09=09=20=09=20=20=20=09=09=20=20

--=20
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance