I would like to stand up as being very much in favor of two related things:
(1) adjustable blocksizes
(2) a larger MAX TUPLE size
As far as I can tell (and that ain't far), there would only be relatively
minor changes that would have to be made to give the option of allowing
the user to select 2, 4, 8 or 16 as the blocksize. Concurrently, it
would seem wise to simply up the max tuple size to 32k. It seems to me
unlikely that this would have a noticeable performance impact. In order
to do this, we would need to know about the 32 bit ItemIdData structure in
/storage/itemid.h (see my previous posts). It was recommended to me that
lp_flags might still be only using 2 of the 6 bits allocated to it. If
so, increasing lp_offset to 15 and lp_len to 15, i.e. 2^15 bits, i.e.
32768 bytes max tuple size, would be possible! I think!
Just my 2 cents.
Eddie