Re: 8.3 synchronous_commit

Поиск
Список
Период
Сортировка
Искать
От
Florian Weimer
Тема
Re: 8.3 synchronous_commit
Дата
Msg-id
82d4rumfae.fsf@mid.bfk.de
Ответ на
8.3 synchronous_commit (Hannes Dorbath)
Список
Дерево обсуждения
8.3 synchronous_commit Hannes Dorbath <light@theendofthetunnel.de>
Re: 8.3 synchronous_commit Jeff Davis <pgsql@j-davis.com>
Re: 8.3 synchronous_commit "Pavel Stehule" <pavel.stehule@gmail.com>
Re: 8.3 synchronous_commit Florian Weimer <fweimer@bfk.de>
Re: 8.3 synchronous_commit "Guillaume Smet" <guillaume.smet@gmail.com>
Re: 8.3 synchronous_commit Hannes Dorbath <light@theendofthetunnel.de>
Re: 8.3 synchronous_commit Florian Weimer <fweimer@bfk.de>
Re: 8.3 synchronous_commit Greg Smith <gsmith@gregsmith.com>
Re: 8.3 synchronous_commit Jeff Davis <pgsql@j-davis.com>
Re: 8.3 synchronous_commit Fernando Ike <fike@midstorm.org>
Re: 8.3 synchronous_commit Greg Smith <gsmith@gregsmith.com>
Re: 8.3 synchronous_commit Hannes Dorbath <light@theendofthetunnel.de>
* Hannes Dorbath:

> I might completely misunderstand this feature. Shouldn't
> "synchronous_commit = off" improve performance?

Indeed.

We've seen something similar in one test, but couldn't reproduce it in
a clean environment so far.

> Maybe it's just my test box.. single SATA-II drive, XFS on top of LVM.

Ours was ext3, no LVM or RAID.

-- 
Florian Weimer                
BFK edv-consulting GmbH       http://www.bfk.de/
Kriegsstraße 100              tel: +49-721-96201-1
D-76133 Karlsruhe             fax: +49-721-96201-99
В списке pgsql-performance по дате отправления
От: Adrian Moisey
Дата:
Сообщение: Re: scheduler
От: david@lang.hm
Дата:
Сообщение: Re: scheduler
FAQ