Re: [HACKERS] MAX Query length

"Ansley, Michael" <Michael.Ansley@intec.co.za> writes:
> At present, disk blocks are set to 8k.  Is it as easy as just adjusting the
> constant to enlarge this?  Testing queries larger than 16k with only an 8k
> tuple size could be challenging.

As of 6.5, it's just a matter of adjusting BLCKSZ in include/config.h,
rebuilding, and re-initdb-ing.  The workable sizes are 8k 16k and 32k;
bigger than 32k fails for reasons I don't recall exactly (offsets
stored in signed shorts somewhere, no doubt).

> Is somebody actively working on removing the tuple-length dependence on the
> block size?

There was considerable discussion about it a few weeks ago, but I didn't
hear anyone actually committing to do the work :-(.  Maybe when you've
made some progress on the text-length issues, someone will get excited
about the tuple-length issue...
        regards, tom lane