Re: Which platfform do you recommend?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

On Mon, 11 Oct 2004 nd02tsk(at)student(dot)hig(dot)se wrote:

> I am wondering which plattform PostgreSQL performs best under?
> I am doing a comparison with MySQL which, according to their manual, runs
> best under Linux 2.4 with ReiserFS on x86.

Reiserfs runs better if you have files that have small sizes. So MySQL
could run better on reiser; since it is a "small" database ;-)

As far as I've tried, Red Hat family (RHEL, FC X ) and FreeBSD are the
optimal OSes.

For Linux, ext3 seems better, but under some circumstances ext2 could run
more stable. Check pgsql-perform list archives for more discussions on
filesystems on Linux.

Umm... I've been testing PostgreSQL on Linxu 2.6.X for a long time under
heavy load. I don't have the benchmarks, but I can say that many things
runs faster and faster on 2.6 than 2.4.

- -HTH
- --
Devrim GUNDUZ
devrim~gunduz.org devrim.gunduz~linux.org.tr
http://www.tdmsoft.com
http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFBbFz5tl86P3SPfQ4RAkNIAJ9Is8fd3HaprAx3b/o1aVVEQEkBvwCeJ/Q0
vu/3P6AavTQvOgIe848JrF8=
=DISv
-----END PGP SIGNATURE-----