Re: [HACKERS] MAX Query length

"Ansley, Michael" <Michael(dot)Ansley(at)intec(dot)co(dot)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