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

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Samuel GendlerDate: 2010-08-18 22:06:43
Subject: Re: write barrier question
Previous:From: Yeb HavingaDate: 2010-08-18 20:25:27
Subject: Re: write barrier question

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