Re: write barrier question

From: Samuel Gendler <sgendler(at)ideasculptor(dot)com>
To: Craig James <craig_james(at)emolecules(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: write barrier question
Date: 2010-08-18 22:05:27
Message-ID: AANLkTintmhEQdWPU-mcxfSP8uSDwJ4ZMTGSyLFeOJV9y@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I am. I was giving mean numbers

On Wed, Aug 18, 2010 at 12:56 PM, Craig James
<craig_james(at)emolecules(dot)com> wrote:
> On 8/18/10 12:24 PM, Samuel Gendler wrote:
>>
>> With barriers off, I saw a transaction rate of about 1200.  With
>> barriers on, it was closer to 1050.  The test had a concurrency of 40
>> in both cases.
>
> I discovered there is roughly 10-20% "noise" in pgbench results after
> running the exact same test over a 24-hour period on a machine with no other
> activity.  Be sure you run your tests enough times to get good statistics
> unless you're looking at much larger differences.
>
> Craig
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Samuel Gendler 2010-08-18 22:06:43 Re: write barrier question
Previous Message Yeb Havinga 2010-08-18 20:25:27 Re: write barrier question