Re: Configuring BLCKSZ and XLOGSEGSZ (in 8.3)

On 11/27/06, Peter Eisentraut <peter_e(at)gmx(dot)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(at)gmail(dot)com
GPLS -- PINES Development
Database Developer
http://open-ils.org