huge difference in TPS depending of synchornous_commit setting

Поиск
Список
Период
Сортировка
От Sergey Kirillov
Тема huge difference in TPS depending of synchornous_commit setting
Дата
Msg-id CAJjUSnD8YJn3H3UP6tPLWaqntOgZbW-AV_qPhNi6gr8d8XNgYA@mail.gmail.com
обсуждение исходный текст
Ответы Re: huge difference in TPS depending of synchornous_commit setting  (Jesper Krogh <jesper@krogh.cc>)
Re: huge difference in TPS depending of synchornous_commit setting  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-novice
Дерево обсуждения
Hi. 

I'm having problems with PostgreSQL performance.

My server has good CPU and lots of memory, but just two SATA 7200 hard drives in software RAID1.

When running pgbench I'm getting 68 TPS with synchronous_commit turned on, and 3100 TPS with synchronous commit turned off.

Can somebody tell me why there is such big difference? Is it normal to have it like this?

PS: During run of pgbench with synchronous commit on system is mostly idle, iowait is 0.12%

--
Best regards,
  Sergey

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

Предыдущее
От: Antonio Carlos Salzvedel Furtado Junior
Дата:
Сообщение: Performance issue with virtualized DB
Следующее
От: Jesper Krogh
Дата:
Сообщение: Re: huge difference in TPS depending of synchornous_commit setting