Обсуждение: Which platfform do you recommend?

Поиск
Список
Период
Сортировка

Which platfform do you recommend?

От
nd02tsk@student.hig.se
Дата:
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



Re: Which platfform do you recommend?

От
Devrim GUNDUZ
Дата:
-----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-----

Re: Which platfform do you recommend?

От
Andrew Sullivan
Дата:
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

Re: Which platfform do you recommend?

От
Evan Rempel
Дата:
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


Re: Which platfform do you recommend?

От
Alvaro Herrera
Дата:
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."


Re: Which platfform do you recommend?

От
Christopher Browne
Дата:
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/>

Re: Which platfform do you recommend?

От
Martín Marqués
Дата:
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
-----------------------------------------------------------------

Re: Which platfform do you recommend?

От
Alvaro Herrera
Дата:
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