Marc G. Fournier wrote: > Now, here's a question for someone running a non-FreeBSD OS ... if we were > to jump the BLCKSZ to 16k, would it cause a degradation in performance, or > would it make no difference to them? Would they see an 8% reduction in > performance? > > The thing is ... there has been presented a strong, valid reason for > moving to 16k (at least under FreeBSD) ... and there has been a valid > reason for not making it "easily configurable" ... but, are there any > strong reasons not to just move to 16k across the board?
First, I assume all this discussion about default block size is for 7.5, not for 7.4, which is in beta. Second, the tests were done only for _write_ performance. We can expect random read performance to be worse for larger block sizes, so I think more research needs to be done. Also, Tatsuo reported years ago that he got ~15% performance improvement with a 32k PostgreSQL block size. The OS was AIX or Linux. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
