Re: huge difference in TPS depending of synchornous_commit setting

Поиск
Список
Период
Сортировка
От Sergey Kirillov
Тема Re: huge difference in TPS depending of synchornous_commit setting
Дата
Msg-id CAJjUSnBL89DYB3q+uAffsc6azvxVwbpn-HRzc07fJNi0Owag2w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: huge difference in TPS depending of synchornous_commit setting  (Jesper Krogh <jesper@krogh.cc>)
Список 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

В списке pgsql-novice по дате отправления:

Предыдущее
От: Jesper Krogh
Дата:
Сообщение: Re: huge difference in TPS depending of synchornous_commit setting
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: huge difference in TPS depending of synchornous_commit setting