Home > mailing lists

Re: huge difference in TPS depending of synchornous_commit setting - Mailing list pgsql-novice

From	Sergey Kirillov
Subject	Re: huge difference in TPS depending of synchornous_commit setting
Date	August 9, 2012 07:19:42
Msg-id	CAJjUSnBL89DYB3q+uAffsc6azvxVwbpn-HRzc07fJNi0Owag2w@mail.gmail.com Whole thread Raw
In response to	Re: huge difference in TPS depending of synchornous_commit setting (Jesper Krogh <jesper@krogh.cc>)
List	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@krogh.cc> wrote:

That is to be expected see

http://momjian.us/main/blogs/pgblog/2012.html#August_1_2012

Jesper

--
Best regards,
Sergey

From: Jesper Krogh
Date: 09 August 2012, 07:08:03
Subject: Re: huge difference in TPS depending of synchornous_commit setting

From: Simon Riggs
Date: 09 August 2012, 07:43:06
Subject: Re: huge difference in TPS depending of synchornous_commit setting