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
Message-ID: <COL129-W186A40FA6CEAFEE926F3E692000@phx.gbl> (raw)
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>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Thanks.
Kernel is: 3.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=67108864 and vm.dirty_bytes=536870912 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 next 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.org)
>>> 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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: steven.jones1201@outlook.com, ik@postgresql-consulting.com
Subject: Re: Very slow checkpoints
In-Reply-To: <COL129-W186A40FA6CEAFEE926F3E692000@phx.gbl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox