On Thu, Jan 28, 2016 at 1:34 AM, james <ja...@mansionfamily.plus.com> wrote:
> On 27/01/2016 13:30, Amit Kapila wrote: > >> >> Thoughts? >> >> Are the decreases observed with SSD as well as spinning rust? > > The test is done with WAL on SSD and data on spinning rust, but I think the results should be similar if we would have done it otherwise as well. Having said that, I think still it is worth-while to test it that way and I will do it. > I might imagine that decreasing the wear would be advantageous, Yes. > especially if the performance decrease is less with low read latency. > > Let me clarify again here that with 4096 bytes chunk size, there is no performance decrease observed and rather there is a performance increase though relatively-small (1~5%) and there is a reduction of ~35% disk writes. Only if we do exact writes or write with smaller chunk size like (512 or 1024 bytes, basically lesser than OS block size), then we can see performance decrease mainly for wal_level < ARCHIVE, but then writes are much more smaller. I would also like to mention that what we call reduction in disk writes, this is the 7th column in stat file [1] (write sectors - number of sectors written, for details you can refer documentation of stat file [1]). [1] - https://www.kernel.org/doc/Documentation/block/stat.txt With Regards, Amit Kapila. EnterpriseDB: http://www.enterprisedb.com
