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

From Simon Riggs
Subject Re: survey of WAL blocksize changes
Date
Msg-id 1243414009.24860.134.camel@ebony.2ndQuadrant
Whole thread Raw
In response to survey of WAL blocksize changes  (Mark Wong <markwkm@gmail.com>)
Responses Re: survey of WAL blocksize changes  (Mark Wong <markwkm@gmail.com>)
List pgsql-hackers
On Tue, 2009-05-26 at 19:51 -0700, Mark Wong wrote:
> It appears for this workload using a 16KB or 32KB gets more than 4%
> throughput improvement, but some of that could be noise. 

The baseline appears to have a significant jump in txn response time
after 77 mins on the baseline test. I think you should rerun that. My
guess would be it will reduce any gains shown with higher settings.

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Training, Services and Support



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: PostgreSQL Developer meeting minutes up
Next
From: Dimitri Fontaine
Date:
Subject: Re: search_path vs extensions