Skip site navigation (1) Skip section navigation (2)

Re: MySQL and PostgreSQL speed compare

From: "Gordan Bobic" <gordan(at)freeuk(dot)com>
To: "PostgreSQL General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: MySQL and PostgreSQL speed compare
Date: 2000-12-29 13:52:38
Message-ID: 002b01c0719e$9d452620$8000000a@localdomain (view raw or flat)
Thread:
Lists: 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

Next:From: Jarmo PaavilainenDate: 2000-12-29 14:35:08
Subject: SV: MySQL and PostgreSQL speed compare
Previous:From: Alfred PerlsteinDate: 2000-12-29 13:51:29
Subject: Re: MySQL and PostgreSQL speed compare

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group