Re: Configuring BLCKSZ and XLOGSEGSZ (in 8.3) - Mailing list pgsql-hackers

From Zdenek Kotala
Subject Re: Configuring BLCKSZ and XLOGSEGSZ (in 8.3)
Date
Msg-id 45708E85.1000107@sun.com
Whole thread Raw
In response to Re: Configuring BLCKSZ and XLOGSEGSZ (in 8.3)  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: FOR SHARE vs FOR UPDATE locks
Next
From: "Simon Riggs"
Date:
Subject: Re: FOR SHARE vs FOR UPDATE locks