Re: write barrier question

From: Craig James <craig_james(at)emolecules(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: write barrier question
Date: 2010-08-18 19:56:57
Message-ID: 4C6C3B09.6040504@emolecules.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message s anwar 2010-08-18 20:09:39 Copy performance issues
Previous Message Samuel Gendler 2010-08-18 19:24:28 write barrier question