Re: [PERFORM] PGSQL, checkpoints, and file system syncs

2014-04-03 Thread Ilya Kosmodemiansky
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 wrote: >> Try setting the vm.dirty_bytes sysctl. Something like 256MB might be a good >> starting point. --

Re: [PERFORM] PGSQL, checkpoints, and file system syncs

2014-04-03 Thread Reza Taheri
> Try setting the vm.dirty_bytes sysctl. Something like 256MB might be a good > starting point. > > This comes up fairly often, see e.g.: > http://www.postgresql.org/message-id/flat/27C32FD4-0142-44FE-8488- > 9f366dc75...@mr-paradox.net > > - Heikki Thanks, Heikki. That sounds like my problem al

Re: [PERFORM] PGSQL, checkpoints, and file system syncs

2014-04-03 Thread Heikki Linnakangas
On 04/03/2014 08:39 PM, Reza Taheri wrote: Hello PGSQL performance community, You might remember that I pinged you in July 2012 to introduce the TPC-V benchmark. I am now back with more data, and a question about checkpoints. As far as the plans for the benchmark, we are hoping to release a ben