RE: Ideal hardware configuration for pgsql - Mailing list pgsql-general

I think that all this fat should be put on the fire.
A nice performance test on the same high end hardware would be good. Is
there a test suite that would suit?
Would anyone expect more than a 5% difference in performance between the
OS's even using the dreaded ext2 and not the reiserfs or SGI XFS. There
could there be wagers between the loudest in both camps? A 5% betting
premium could apply with all proceeds going to the postgresl development
team :)


My preference for using linux is that I like the licence and spirit of linux
more and assuming that the performance difference is negligable I'll stick
with it.
Similiarly many find that the BSD licence and associated community's
stricter development methodologies appeals more and they too will stick with
that whilst there is a negligable performance difference. But realistly
after using both I find that you can make one choke while the other sings if
you chose your test carefully enough and currently they get similiar
performance results on most general application tests.


--
Ian Willis

-----Original Message-----
From: GH [mailto:grasshacker@over-yonder.net]
Sent: Thursday, 3 May 2001 10:53 AM
To: Ryan Mahoney
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Ideal hardware configuration for pgsql


On Wed, May 02, 2001 at 08:07:04PM +0100, some SMTP stream spewed forth:
> I only have experience with Red Hat, Solaris 8 (intel), and LinuxPPC.
What
> do you see as the downside of running Red Hat?  My intention is to run RH
> 7.1, although I can surely be swayed if you can offer some compelling
> FreeBSD benefits.

FreeBSD is out-of-the-box more secure, more stable, and generally more
enjoyable to work with than RedHat. If you had ever seen the power and
beauty of FreeBSD, you would not continue using RedHat by choice.

You probably need to see it to believe it.
I encourage you to check it out sometime, but you should have no problem
at all running PostgreSQL on RedHat.


I'm out.

gh

>
> BTW, the input on hardware was very useful.  I ordered a Dell today w/ gig

> ram, dual 1ghz PIII and Raid 1 18gig scsi hard drives.  I'm excited!
>
> -r
>
> At 06:52 PM 5/2/01 -0500, GH wrote:
>
> >On Tue, May 01, 2001 at 11:35:13PM +0100, some SMTP stream spewed forth:
> > > Our db server running 7.1 got *torched* today, system ran between 30%
an
> > > 80% CPU all day!  Right now the server is running on a Penguin
Computing
> > > 800mhz PIII w/ 128 ram and IDE hardware.
> > >
> > > Tomorrow I'd like to place an order for something more robust...
looking
> > > into dual PIII, gig of ram and SCSI Raid.  Planning on running Red Hat
7.1
> > > on this machine.
> >
> >I think that anyone whose opinion matters would recommend running
> >something *other* than RedHat. FreeBSD is an excellent operating system
> >and is well suited to a PostgreSQL environment.
> >
> >
> >gh
> >
> >*snip*
> > > You're input is tremendously appreciated!
> > >
> > > -r
> > >
> > > Ryan Mahoney
> > > CTO, Payment Alliance, Inc.
> > > ryan@paymentalliance.net
> > > t. 718-721-0338
> > > m. 718-490-5464
> > > www.paymentalliance.net
> >
> > >
> > > ---
> > > Outgoing mail is certified Virus Free.
> > > Checked by AVG anti-virus system (http://www.grisoft.com).
> > > Version: 6.0.250 / Virus Database: 123 - Release Date: 4/18/01
> >
> > >
> > > ---------------------------(end of
broadcast)---------------------------
> > > TIP 6: Have you searched our list archives?
> > >
> > > http://www.postgresql.org/search.mpl
> >
> >
> >
> >
> >---
> >Incoming mail is certified Virus Free.
> >Checked by AVG anti-virus system (http://www.grisoft.com).
> >Version: 6.0.250 / Virus Database: 123 - Release Date: 4/18/01

>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.250 / Virus Database: 123 - Release Date: 4/18/01


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster