Re: [PERFORM] Comments requested on IO performance : new db server

2012-03-10 Thread Tomas Vondra
On 10.3.2012 11:51, Rory Campbell-Lange wrote: > Is a block size of 4096 a good idea both for the filesystem and > postgresql? The analysis here: > http://www.fuzzy.cz/en/articles/benchmark-results-hdd-read-write-pgbench/ > appears to suggest that at least for database block sizes of 4096 > read/w

Re: [PERFORM] Comments requested on IO performance : new db server

2012-03-10 Thread Rory Campbell-Lange
Is a block size of 4096 a good idea both for the filesystem and postgresql? The analysis here: http://www.fuzzy.cz/en/articles/benchmark-results-hdd-read-write-pgbench/ appears to suggest that at least for database block sizes of 4096 read/write performance is much higher than for smaller block si

Re: [PERFORM] Comments requested on IO performance : new db server

2012-03-10 Thread Rory Campbell-Lange
On 09/03/12, Merlin Moncure (mmonc...@gmail.com) wrote: > On Fri, Mar 9, 2012 at 5:15 AM, Rory Campbell-Lange > wrote: > > I've taken the liberty of reposting this message as my addendum to a > > long thread that I started on the subject of adding a new db server to > > our existing 4-year old wor