Re: interesting benchmarks PG/Firebird Linux/Windows fsync/nofsync

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Re: interesting benchmarks PG/Firebird Linux/Windows fsync/nofsync
Дата
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE476B04@algol.sollentuna.se
обсуждение исходный текст
Ответ на interesting benchmarks PG/Firebird Linux/Windows fsync/nofsync  (Chris Mair <list@1006.org>)
Список pgsql-performance
> One thing that stands out is how terribly bad Windows
> performed with many small single transactions and fsync=true.
>
> Appearantly fsync on Windows is a very costly operation.

What's the hardware? If you're running on disks with write cache
enabled, fsync on windows will write through the write cache *no matter
what*. I don't know of any other OS where it will do that.

If you don't have a battery backed write cache, then all other
configurations are considered very dangerous in case your machine
crashes.

If you have battery backed write cache, then yes, pg on windows will
perform poorly indeed.


There is a patch in the queue for 8.0.2, and already applied to 8.1
IIRC, that will fix the bad performance with write-cache on win32.

(can't read the PDF, it crashes my adobe reader for some reason. Perhaps
it contains the information above...)

//Magnus

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

Предыдущее
От: Chris Mair
Дата:
Сообщение: interesting benchmarks PG/Firebird Linux/Windows fsync/nofsync
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: interesting benchmarks PG/Firebird Linux/Windows fsync/nofsync