Re: [HACKERS] MAX Query length - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] MAX Query length
Date
Msg-id 6093.932047133@sss.pgh.pa.us
Whole thread Raw
In response to RE: [HACKERS] MAX Query length  ("Ansley, Michael" <Michael.Ansley@intec.co.za>)
Responses Re: [HACKERS] MAX Query length
List pgsql-hackers
"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


pgsql-hackers by date:

Previous
From: "Ansley, Michael"
Date:
Subject: RE: [HACKERS] MAX Query length
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] MAX Query length