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 r...@campbell-lange.net 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

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

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/write

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

2012-03-09 Thread Rory Campbell-Lange
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 workhorse got lost in discussion. Our workload is several small databases totalling less than 40GB of disk space. The proposed system

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

2012-03-09 Thread Merlin Moncure
On Fri, Mar 9, 2012 at 5:15 AM, Rory Campbell-Lange r...@campbell-lange.net 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 workhorse got lost in discussion. Our workload