Re: Intel 710 pgbench write latencies

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Yeb Havinga <yebhavinga(at)gmail(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Intel 710 pgbench write latencies
Date: 2011-11-02 21:08:38
Message-ID: CAHyXU0z7GriCtS7LznwmvF_pKBbn-oOtT8mpnjF2Z20n++5LQg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Nov 2, 2011 at 3:45 PM, Yeb Havinga <yebhavinga(at)gmail(dot)com> wrote:
> On 2011-11-02 16:16, Yeb Havinga wrote:
>>
>> On 2011-11-02 15:26, Merlin Moncure wrote:
>>
>>> I would keep at least 20-30% of both drives unpartitioned to leave the
>>> controller room to wear level and as well as other stuff.  I'd try
>>> wiping the drives, reparititoing, and repeating your test.  I would
>>> also compare times through mdadm and directly to the device.
>>
>> Good idea.
>
> Reinstalled system - > 50% drives unpartitioned.
> /dev/sdb3              19G  5.0G   13G  29% /ocz
> /dev/sda3              19G  4.8G   13G  28% /intel
> /dev/sdb3 on /ocz type ext4 (rw,noatime,nobarrier,discard)
> /dev/sda3 on /intel type ext4 (rw,noatime,nobarrier,discard)
>
> Again WAL was put in a ramdisk.
>
> pgbench -i -s 300 t # fits in ram
> pgbench -c 20 -M prepared -T 300 -l  t
>
> Intel latency graph at http://imgur.com/Hh3xI
> Ocz latency graph at http://imgur.com/T09LG

curious: what were the pgbench results in terms of tps?

merlin

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message CS DBA 2011-11-02 21:53:28 Re: Poor performance on a simple join
Previous Message Scott Marlowe 2011-11-02 20:45:56 Re: Poor performance on a simple join