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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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