Re: Bumping block size to 16K on FreeBSD...

> > Are there any objections to me increasing the block size for
> > FreeBSD installations to 16K for the upcoming 7.4 release?
>
> I'm a little uncomfortable with introducing a cross-platform
> variation in the standard block size. That would have implications
> for things like whether a table definition that works on FreeBSD
> could be expected to work elsewhere; to say nothing of
> recommendations for shared_buffer settings and suchlike.

Hrm, well, given things just went to beta2, I'm going to bump
postgresql-devel to beta2 and include this patch for now, however, I'm
going to explicitly requests that people who have problems or
successes with beta2 on FreeBSD ask me before possible reporting
problems with a platform specific alteration.

That said, however, an 8% speedup on writes is non-trivial and
something I'd like to pick up if possible. :) I have faith that PG
does the right thing as I'm sure other people have done this w/o
incident in the past, I just don't think anyone's tuned this for the
platform and all of its users.

> Also, there is no infrastructure for adjusting BLCKSZ automatically
> at configure time, and I don't much want to add it.

The patch gets applied when the port gets built, so there doesn't need
to be a configuration option for it for this to work.

--
Sean Chittenden