Re: PGSQL, checkpoints, and file system syncs - Mailing list pgsql-performance

From Ilya Kosmodemiansky
Subject Re: PGSQL, checkpoints, and file system syncs
Date
Msg-id CAG95seVOrb4JA0G2wbsgYBk8QC5PbdGL85xBMSsuu7CZexiOMA@mail.gmail.com
Whole thread Raw
In response to Re: PGSQL, checkpoints, and file system syncs  (Reza Taheri <rtaheri@vmware.com>)
Responses Re: PGSQL, checkpoints, and file system syncs
List pgsql-performance
Hi Reza,

vm.dirty_bytes indeed makes sense, but just in case: how exactly is
your ext4 mount? Particularly, have you disabled barrier?

Ilya

On Thu, Apr 3, 2014 at 8:11 PM, Reza Taheri <rtaheri@vmware.com> wrote:
>> Try setting the vm.dirty_bytes sysctl. Something like 256MB might be a good
>> starting point.



--
Ilya Kosmodemiansky,

PostgreSQL-Consulting.com
tel. +14084142500
cell. +4915144336040
ik@postgresql-consulting.com


pgsql-performance by date:

Previous
From: Reza Taheri
Date:
Subject: Re: PGSQL, checkpoints, and file system syncs
Next
From: Varadharajan Mukundan
Date:
Subject: Fwd: Slow Count-Distinct Query