Обсуждение: Which platfform do you recommend?
Hello 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. Thank you. Tim
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, On Mon, 11 Oct 2004 nd02tsk@student.hig.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-----
On Wed, Oct 13, 2004 at 01:38:45AM +0300, Devrim GUNDUZ wrote: > > 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. Some time ago, Chris Browne posted some test results he did. It turned out that jfs beat xfs, and that either of them completely trounced both reiser and ext3. In particular, ext3 was just plain slow. We won't consider ext2 because it's too dangerous in case of crash. A -- Andrew Sullivan | ajs@crankycanuck.ca In the future this spectacle of the middle classes shocking the avant- garde will probably become the textbook definition of Postmodernism. --Brad Holland
Do you have a reference for the post that Chris Browne made? I would be very interested to see the performance differences for the different filesystems. Evan. On Fri, 15 Oct 2004, Andrew Sullivan wrote: > Date: Fri, 15 Oct 2004 12:33:39 -0400 > From: Andrew Sullivan <ajs@crankycanuck.ca> > To: pgsql-advocacy@postgresql.org > Subject: Re: [pgsql-advocacy] Which platfform do you recommend? > > On Wed, Oct 13, 2004 at 01:38:45AM +0300, Devrim GUNDUZ wrote: > > > > 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. > > Some time ago, Chris Browne posted some test results he did. It > turned out that jfs beat xfs, and that either of them completely > trounced both reiser and ext3. In particular, ext3 was just plain > slow. We won't consider ext2 because it's too dangerous in case of > crash. > > A > > -- > Andrew Sullivan | ajs@crankycanuck.ca > In the future this spectacle of the middle classes shocking the avant- > garde will probably become the textbook definition of Postmodernism. > --Brad Holland > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html > -- Evan Rempel erempel@uvic.ca Senior Programmer Analyst 250.721.7691 Computing Services University of Victoria
On Fri, Oct 15, 2004 at 09:51:37AM -0700, Evan Rempel wrote: > Do you have a reference for the post that Chris Browne made? > I would be very interested to see the performance differences for the > different filesystems. http://www.pgsql.ru http://archives.postgresql.org/pgsql-general/2003-11/msg01692.php -- Alvaro Herrera (<alvherre[a]dcc.uchile.cl>) "No renuncies a nada. No te aferres a nada."
The world rejoiced as ajs@crankycanuck.ca (Andrew Sullivan) wrote: > On Wed, Oct 13, 2004 at 01:38:45AM +0300, Devrim GUNDUZ wrote: >> >> 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. > > Some time ago, Chris Browne posted some test results he did. It > turned out that jfs beat xfs, and that either of them completely > trounced both reiser and ext3. In particular, ext3 was just plain > slow. We won't consider ext2 because it's too dangerous in case of > crash. Minor quibble... ... I didn't consider reiserfs at all, for three reasons: 1. We weren't seriously considering considering it because for DBMS work, it's pretty experimental even yet 2. None of the vendors we were dealing with would offer support for it. 3. It's consciously optimized for dealing with small files, and there are conspicuous reports of it slowing down when dealing with large files. Big DBs --> large files... Drop mention of reiserfs from that and the rest is certainly a fair assessment. -- "cbbrowne","@","ntlug.org" http://www3.sympatico.ca/cbbrowne/nonrdbms.html Rules of the Evil Overlord #15. "I will never employ any device with a digital countdown. If I find that such a device is absolutely unavoidable, I will set it to activate when the counter reaches 117 and the hero is just putting his plan into operation." <http://www.eviloverlord.com/>
El Vie 15 Oct 2004 14:53, Alvaro Herrera escribió: > On Fri, Oct 15, 2004 at 09:51:37AM -0700, Evan Rempel wrote: > > Do you have a reference for the post that Chris Browne made? > > I would be very interested to see the performance differences for the > > different filesystems. > > http://www.pgsql.ru > > http://archives.postgresql.org/pgsql-general/2003-11/msg01692.php What about if the FS is over a RAID? How important is the FS choice in those cases? And by the way, what's the best RAID configuration for a database with fairly equal reads vs. writes? -- 16:45:02 up 33 days, 7:03, 2 users, load average: 0.53, 0.32, 0.26 ----------------------------------------------------------------- Martín Marqués | select 'mmarques' || '@' || 'unl.edu.ar' Centro de Telematica | DBA, Programador, Administrador Universidad Nacional del Litoral -----------------------------------------------------------------
On Fri, Oct 15, 2004 at 04:49:46PM -0300, Martín Marqués wrote: > El Vie 15 Oct 2004 14:53, Alvaro Herrera escribió: > > On Fri, Oct 15, 2004 at 09:51:37AM -0700, Evan Rempel wrote: > > > Do you have a reference for the post that Chris Browne made? > > > I would be very interested to see the performance differences for the > > > different filesystems. > > > > http://www.pgsql.ru > > > > http://archives.postgresql.org/pgsql-general/2003-11/msg01692.php > > What about if the FS is over a RAID? How important is the FS choice in those > cases? Dunno about RAID, but search about Joe Conway's weird problems with LVM and XFS ... and be afraid --- be very afraid. And test a lot. -- Alvaro Herrera (<alvherre[a]dcc.uchile.cl>) "Before you were born your parents weren't as boring as they are now. They got that way paying your bills, cleaning up your room and listening to you tell them how idealistic you are." -- Charles J. Sykes' advice to teenagers