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

From Ansley, Michael
Subject RE: [HACKERS] MAX Query length
Date
Msg-id 1BF7C7482189D211B03F00805F8527F70ED041@S-NATH-EXCH2
Whole thread Raw
Responses Re: [HACKERS] MAX Query length
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Louis Bertrand
Date:
Subject: Re: [HACKERS] Updated TODO list
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] MAX Query length