Re: MySQL and PostgreSQL speed compare

Поиск
Список
Период
Сортировка
От Gordan Bobic
Тема Re: MySQL and PostgreSQL speed compare
Дата
Msg-id 002b01c0719e$9d452620$8000000a@localdomain
обсуждение исходный текст
Ответ на MySQL and PostgreSQL speed compare  ("Jarmo Paavilainen" <netletter@comder.com>)
Список pgsql-general
> But isn't it recommended to run the server with fsync?  If so, you
shouldn't
> disable it on a benchmark then.

Recommended for what? If you have a system that has to be up 24/7, then you
should have:

1) Sound, working hardware
2) UPS
3) Failovers / RAID
4) Backups

Provided that:

(you don't get a hardware failure, OR you have implemented 3)),
AND
(you don't get a power cut OR you have implemented 2)),

then there is no danger that I can see in having the OS handle your disk
caching. If you have a hardware caching controler, then the whole fsync
issue is slightly more academic, but disabling fsync will generally always
improve performance.

IMHO, if you don't trust your hardware and arrangements enough to feel
happy with switching off fsync, then you shouldn't be using that setup in a
mission critical application. It's OK for a development system where you
expect the system to be trashed several times a week, but I am not sure
that fsync should be high enough on the list of priorities in a mission
crytical system to be worth worrying about too much.

Feel free to disagree...

Regards.

Gordan




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

Предыдущее
От: Alfred Perlstein
Дата:
Сообщение: Re: MySQL and PostgreSQL speed compare
Следующее
От: "Gordan Bobic"
Дата:
Сообщение: Re: MySQL and PostgreSQL speed compare