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

It's sitting right here on my desk.  Ask whatever you want.

Yes they are better web servers than DBMS servers but if you
database is small enough to cache in RAM then who care if
the Netra uses slow disks?

All that talk on this list about Linux vs. BSD is silly.
Why bother when you can have Solaris 8 on SPARC hardware?

On the Netra Sun has added "LOM" this is a little shell-like
program burned in ROM that runs on some micro controller,
not on the SPARC CPU. It stays up even when the CPU, RAM
and disks are powered off and the cooling fans are off.
They still have the old OK> prompt but you don't need to
use it much.  LOM will run when Solaris is up too.

The Netra is best when you stack them in a rack.  You
get a system with 40 CPUs, 80 Disks, 8Gb network
bandwidth, for under $40K All in one telco rack.

> -----Original Message-----
> From: Hunter Hillegas [mailto:lists@lastonepicked.com]
> Sent: Wednesday, May 02, 2001 7:51 PM
> To: Albertson, Chris
> Subject: Re: [GENERAL] Ideal hardware configuration for pgsql
>
>
> I was wondering about those boxes, though more so as Web
> servers... I'm
> interested in any other thoughts you have on 'em.
>
> Hunte
>
> > From: "Albertson, Chris" <CAlbertson@primeadvantage.com>
> > Date: Wed, 2 May 2001 13:01:15 -0700
> > To: "'Willis, Ian (Ento, Canberra)'"
> <Ian.Willis@ento.csiro.au>, "'Ryan
> > Mahoney'" <ryan@paymentalliance.net>, pgsql-general@postgresql.org
> > Subject: RE: [GENERAL] Ideal hardware configuration for pgsql
> >
> >
> > We just bought a brand new Sun Netra X1.  List pice from Sun was
> > $995.00.  Yes under one grand.  It is a 1U tall box.  For once
> > Sun beats Intel prices.  It comes with Solaris 8 preinstaled.
> > Basically just plug in and boot.  We got a discount to $907.
> >
> > We upgraded the RAM to 1GB (it uses PC133 RAM)
> > We also added a second drive and do a two way mirror.
> > I tested it by pulling the power cable from one drive
> > while Postgres was running.  It worked, no crash.
> > The box is not super fast but usfull for many purposes.
> > My test database has 1M rows by 40 columns.  With the
> > 1GB RAM perforance is just "OK".
> >
> > I used a dual Xeon box (2MB L2 cache, 1GB RAM, SCSI 160)
> > that was faster then the Sun Netera X1 but cost 6x more.
> >
> > My Ideal box would have multiple CPUs, at least SCSI 160 drives
> > or better a hardware RAID box and 4GB RAM.
> >
> >
> >
> >> -----Original Message-----
> >> From: Willis, Ian (Ento, Canberra)
> [mailto:Ian.Willis@ento.csiro.au]
> >> Sent: Wednesday, May 02, 2001 12:03 AM
> >> To: 'Ryan Mahoney'; pgsql-general@postgresql.org
> >> Subject: RE: [GENERAL] Ideal hardware configuration for pgsql
> >>
> >>
> >> I would make sure that an intel box won't suit before looking
> >> at sun. Simply
> >> for cost and if you're planning to run linux on it sun
> >> support will be shit
> >> because they don't have skills in that area.
> >> Databases thrive on more spindles, separate system spindles
> >> from the db
> >> spindles and swap spindles, look at separating index tables
> >> from data tables
> >> and the WAL.
> >> Raid 3 or striping may be more suitable for the WAL (what
> >> happens if you
> >> loose the WAL?) whereas raid 5 or a combination for 1/5
> for data and
> >> indexes. The chunk size on a raid set may also be worth
> >> pursuing as a means
> >> of squeezing better performance from a dedicated db machine.
> >>
> >> --
> >> Ian Willis
> >> Systems Administrator
> >> Division of Entomology CSIRO
> >> GPO Box 1700
> >> Canberra ACT 2601
> >> ph  02 6246 4391
> >> fax 02 6246 4000
> >>
> >>
> >> -----Original Message-----
> >> From: Ryan Mahoney [mailto:ryan@paymentalliance.net]
> >> Sent: Wednesday, 2 May 2001 8:35 AM
> >> To: pgsql-general@postgresql.org
> >> Subject: [GENERAL] Ideal hardware configuration for pgsql
> >>
> >>
> >> 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.
> >>
> >> Before I order, I was wondering if anyone had any suggestions or
> >> recommendations.  I have been considering getting a Sun
> >> machine... but I
> >> don't know if there is a benefit.  Also, are there any special
> >> considerations when running RAID and dual CPU?
> >>
> >> 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
> >>
> >> ---------------------------(end of
> >> broadcast)---------------------------
> >> TIP 3: if posting/reading through Usenet, please send an
> appropriate
> >> subscribe-nomail command to majordomo@postgresql.org so that your
> >> message can get through to the mailing list cleanly
> >>
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> >
>