Re: MySQL and PostgreSQL speed compare - Mailing list pgsql-general

From Gordan Bobic
Subject Re: MySQL and PostgreSQL speed compare
Date
Msg-id 002b01c0719e$9d452620$8000000a@localdomain
Whole thread Raw
In response to MySQL and PostgreSQL speed compare  ("Jarmo Paavilainen" <netletter@comder.com>)
List 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 by date:

Previous
From: Alfred Perlstein
Date:
Subject: Re: MySQL and PostgreSQL speed compare
Next
From: "Gordan Bobic"
Date:
Subject: Re: MySQL and PostgreSQL speed compare