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

Re: huge difference in TPS depending of synchornous_commit setting

From: Sergey Kirillov <sergey(dot)kirillov(at)gmail(dot)com>
To: Jesper Krogh <jesper(at)krogh(dot)cc>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: huge difference in TPS depending of synchornous_commit setting
Date: 2012-08-09 07:19:10
Message-ID: CAJjUSnBL89DYB3q+uAffsc6azvxVwbpn-HRzc07fJNi0Owag2w@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Thanks. I was thinking that is is related to rotational delay too. But 68
TPS still look a bit slow for me.

On the another (slower) server with 4 SATA disks in RAID-10, I'm getting
~250 TPS, which is almost 4X of my new server.

And this is weird for me since, if I'm getting everything right — 4 disks
in RAID-10 should be only 2x faster than 2 disks in RAID-1

On Thu, Aug 9, 2012 at 10:07 AM, Jesper Krogh <jesper(at)krogh(dot)cc> wrote:

> That is to be expected see
>
> http://momjian.us/main/blogs/pgblog/2012.html#August_1_2012
>
> Jesper
>



-- 
Best regards,
  Sergey

In response to

pgsql-novice by date

Next:From: Simon RiggsDate: 2012-08-09 07:38:18
Subject: Re: huge difference in TPS depending of synchornous_commit setting
Previous:From: Jesper KroghDate: 2012-08-09 07:07:17
Subject: Re: huge difference in TPS depending of synchornous_commit setting

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