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 pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073