Re: Configuring BLCKSZ and XLOGSEGSZ (in 8.3)

On 11/27/06, Peter Eisentraut <peter_e@gmx.net> wrote:
> Am Montag, 27. November 2006 12:30 schrieb Simon Riggs:
> > It seems possible to vary both BLCKSZ and XLOGSEGSZ rather than have
> > them set within pg_config_manual. There are a number of use-cases where
> > varying these values will offer increased performance
>
> Such as?

Reading 32k at a time from my SAN, instead of 8k, gave me a ~15%
increase in overall I/O throughput.  Now, I'm not certain that I
didn't do something else stupid that the BLCKSZ partially counter
acts, but dd bears out my results (and 64k is even faster for dd).

>
> --
> Peter Eisentraut
> http://developer.postgresql.org/~petere/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>


-- 
Mike Rylander
mrylander@gmail.com
GPLS -- PINES Development
Database Developer
http://open-ils.org