RE: Ideal hardware configuration for pgsql/Netra
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.
Show quoted text
-----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 pgsqlI 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 pgsqlWe 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 pgsqlI 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/5for 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 pgsqlOur 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 anappropriate
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
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?
Easy: Cost.
(And, there are other reasons, of course, but I won't turn this into a
Solaris-bash. : ) )
steve
On Thu, May 03, 2001 at 12:52:24PM -0700, some SMTP stream spewed forth:
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?
Does anybody ever actually *READ* the $%@#-ing threads?
I never said a word about Linux. RedHat does *NOT* equal LINUX!
Somebody claimed that my post was uninformed...yet RedHat is all of Linux
now?
If you are going to refute a statement, please at least have the decency
to READ it.
Can we end this?
gh
Uhh.. OS wars are silly. Use what ever OS you like.
We should discuss PostgreSQL here, not operating systems (at least not in
the classic flame-war style)..
*sigh*
-Mitch
GH <grasshacker@over-yonder.net> writes:
Somebody claimed that my post was uninformed...yet RedHat is all of Linux
now?
No, of course not. Red Hat is more than Linux, Linux is more than our
version of it: Red Hat Linux.
--
Trond Eivind Glomsr�d
Red Hat, Inc.
GH wrote:
Does anybody ever actually *READ* the $%@#-ing threads?
I never said a word about Linux. RedHat does *NOT* equal LINUX!
Asbestos longjohns worn thin, GH? :-> Try kevlar next time.
No, Red Hat != Linux -- but the venom in your post required an
appropriate response, as the 'between the lines' interpretation was the
same stuff I've heard -- from since before there was a Linux, or a
FreeBSD. Or a Red Hat. And I read your entire post.
PostgreSQL, to me, is such as valuable RDBMS precisely because it is so
cross-platform -- indeed, it is platform agnostic to an extreme. The
development group is also collectively platform-agnostic (in reality --
although Marc and others play the BSD zealot on-list).
Hey, I'm platform agnostic -- let's go with some serious iron here and
run something hard-core on a mainframe -- PostgreSQL is just as at home
on big iron as it is on my measly Pentium III's and Pentium Pro. But
Red Hat Linux can be and is many times a good fit for the job at hand.
But really, what got my bile in a boil was the 'anyone whose opinion
matters' jibe. That was uncalled for, and required, IMNSHO, a response
in kind -- which, to tell the truth, felt odd to write for this list.
But a post that implied that someone who would recommend Red Hat is a
luser really bothered me.
If that offends others on the list, my apologies. From the email I've
received off-list, I think I am at least temporarily in safe waters.
But, I'm done for now.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
-----Original Message-----
From: Steve Wolfe [mailto:steve@iboats.com]
Sent: Thursday, May 03, 2001 1:46 PM
All that talk on this list about Linux vs. BSD is silly.
Why bother when you can have Solaris 8 on SPARC hardware?Easy: Cost.
We paid $907.00 (yes under a grand)for the rack mount server with
Solaris installed. Just plug in an boot. We bought in brand new,
in the box directly from Sun.
Find a bootable 1U tall intel box with Linux or BSD preinstalled
for $907.00 Next with your <$900.00 BSD box. I will go into your
server room and pull out +either+ all the RAM or the power plugs from
your disk drives. Next see you can tell me which I did without going
in the room.
I guess I could install BSD or Linux on the box if I wanted
but I don't need to. I just put all the GNU stuff in
/usr/local/bin and do a PATH=/usr/local/bin:$PATH
Import Notes
Resolved by subject fallback