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 по дате отправления: