Re: Configuring BLCKSZ and XLOGSEGSZ (in 8.3)

Поиск
Список
Период
Сортировка
От Zdenek Kotala
Тема Re: Configuring BLCKSZ and XLOGSEGSZ (in 8.3)
Дата
Msg-id 45708E85.1000107@sun.com
обсуждение исходный текст
Ответ на Re: Configuring BLCKSZ and XLOGSEGSZ (in 8.3)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane wrote:
> "Simon Riggs" <simon@2ndquadrant.com> writes:
>> It seems possible to vary both BLCKSZ and XLOGSEGSZ rather than have
>> them set within pg_config_manual.
> 
> The work required for this is much larger than you make it out to be,
> and zero evidence has been offered for any benefit.  I have not heard of
> anyone bothering to use a custom BLCKSZ since we added TOAST to get rid
> of the row-length limitation ...

I think, Configurable BLCKSZ could be useful for regression test. See 
hash index problem. Some kind of stress test could be check behavior on 
different BLCKSZ without recompilation.
    Zdenek


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Merlin Moncure"
Дата:
Сообщение: Re: FOR SHARE vs FOR UPDATE locks
Следующее
От: "Simon Riggs"
Дата:
Сообщение: Re: FOR SHARE vs FOR UPDATE locks