RE: [HACKERS] MAX Query length

Поиск
Список
Период
Сортировка
От Ansley, Michael
Тема RE: [HACKERS] MAX Query length
Дата
Msg-id 1BF7C7482189D211B03F00805F8527F70ED041@S-NATH-EXCH2
обсуждение исходный текст
Ответы Re: [HACKERS] MAX Query length  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Louis Bertrand
Дата:
Сообщение: Re: [HACKERS] Updated TODO list
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] MAX Query length