On 13 February 2012 22:49, CSS <css@xxxxxxxxxxx> wrote: > For the top-post scanners, I updated the ssd test to include > changing the zfs recordsize to 8k. > Well now I did, added the results to > http://ns.morefoo.com/bench.html and it looks like there's > certainly an improvement. That's with the only change from the > previous test being to copy the postgres data dir, wipe the > original, set the zfs recordsize to 8K (default is 128K), and then > copy the data dir back. This makes sense simply because it reduces the amount of data read and/or written for non-sequential transactions. > Things that stand out on first glance: > > -at a scaling factor of 10 or greater, there is a much more gentle > decline in TPS than with the default zfs recordsize > -on the raw *disk* IOPS graph, I now see writes peaking at around > 11K/second compared to 1.5K/second. > -on the zpool iostat graph, I do not see those huge write peaks, > which is a bit confusing Could be that "iostat" and "zpool iostat" average raw data differently. > -on both iostat graphs, I see the datapoints look more scattered > with the 8K recordsize As an educated guess, it could be that smaller transaction sizes can "fit in" (in buffers or controller processing paths) where large didn't allowing more bursts of performance. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
