Re: fsync, fdatasync, open_sync, and open_datasync, -- Linux insanity

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: fsync, fdatasync, open_sync, and open_datasync, -- Linux insanity
Дата
Msg-id 5774.1092238619@sss.pgh.pa.us
обсуждение исходный текст
Ответ на fsync, fdatasync, open_sync, and open_datasync, -- Linux insanity  (pgsql@mohawksoft.com)
Список pgsql-hackers
Andreas Pflug <pgadmin@pse-consulting.de> writes:
> Tom Lane wrote:
>> I don't think any test that we could build would be as useful as simply
>> trying the different settings with an installation's real workload.

> Benchmarking the real workload isn't always so easy, and might be quite 
> time consuming to obtain meaningful values.

The concern was about whether people might be missing an easy speedup of
2x or more.  I don't think it'd be that hard to tell ;-) if one setting
is an order of magnitude better than another for your workload.  If
there's not an obvious difference then you haven't wasted much effort
checking.
        regards, tom lane


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

Предыдущее
От: Philip Warner
Дата:
Сообщение: pg_restore (libpq? parser?) bug in 8
Следующее
От: Tom Lane
Дата:
Сообщение: Re: We have got a serious problem with pg_clog/WAL synchronization