Skip site navigation (1) Skip section navigation (2)

Re: survey of WAL blocksize changes

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Mark Wong <markwkm(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: survey of WAL blocksize changes
Date: 2009-05-27 08:46:49
Message-ID: 1243414009.24860.134.camel@ebony.2ndQuadrant (view raw or flat)
Thread:
Lists: 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.com
 PostgreSQL Training, Services and Support


In response to

Responses

pgsql-hackers by date

Next:From: Dimitri FontaineDate: 2009-05-27 08:50:00
Subject: Re: search_path vs extensions
Previous:From: Peter EisentrautDate: 2009-05-27 07:18:51
Subject: Re: PostgreSQL Developer meeting minutes up

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group