RE: [HACKERS] MAX Query length

Once I have recompiled with a new block size, how do I update the databases
that I already have. If I understand right, once the block size has been
updated, my current dbs will not work. Do I just pg_dump before make
install and then recreate the dbs and load the dumps afterwards?

>> 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).

MikeA