Increasing row size beyond 8k
There was some talk a while back of changing the blocksize to 32k in
order to increase possible row size, I need to do this (and don't want to
screw anything up) but am unsure about how to go about it.. Is BLKSZ (if
that's even correct) simply a PG variable somewhere?
I see this in my LINT kernel configuration file (I'm using FreeBSD 4.0)
# BLKDEV_IOSIZE sets the default block size used in user block
# device I/O. Note that this value will be overriden by the label
# when specifying a block device from a label with a non-0
# partition blocksize. The default is PAGE_SIZE.
#
options BLKDEV_IOSIZE=8192
That sounds like what I'm looking for and since it's set to 8k, looks like
what I'm looking for -- so would I be correct in changing this value and
re-compiling my kernel?
Thanks!!!
-Mitch
"Mitch Vincent" <mitch@venux.net> writes:
There was some talk a while back of changing the blocksize to 32k in
order to increase possible row size, I need to do this (and don't want to
screw anything up) but am unsure about how to go about it.. Is BLKSZ (if
that's even correct) simply a PG variable somewhere?
It's near the head of src/include/config.h (or config.h.in if you
are doing the edit before running configure). Edit, rebuild the
system, away you go. Don't forget you will need to initdb after
installing the rebuilt postmaster...
That sounds like what I'm looking for and since it's set to 8k, looks like
what I'm looking for -- so would I be correct in changing this value and
re-compiling my kernel?
No no no, do not touch your kernel.
regards, tom lane