Postgres Pro
Downloads
Home   >   mailing lists

Re: survey of WAL blocksize changes - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: survey of WAL blocksize changes
Date
Msg-id 200905271636.36557.peter_e@gmx.net
Whole thread Raw
In response to survey of WAL blocksize changes  (Mark Wong <markwkm@gmail.com>)
List pgsql-hackers
Tree view 
On Wednesday 27 May 2009 05:51:05 Mark Wong wrote:
> BS notpm % Change from default
> -- ----- ----------
>  1 14673 -4.8%
>  2 15864 2.9%
>  4 15774 2.3%
>  8 15413 (default)
> 16 16118 4.6%
> 32 16051 4.1%
> 64 14874 -3.5%

This means that both somewhat larger and somewhat smaller than 8 give better 
results?!?

pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: generic options for explain
Next
From: Tom Lane
Date:
Subject: Re: Common Table Expressions applied; some issues remain