Re: Tyan Thunder MB for postgres server - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: Tyan Thunder MB for postgres server
Date
Msg-id 1103038201.22049.14.camel@state.g2switchworks.com
Whole thread Raw
In response to Re: Tyan Thunder MB for postgres server  ("Iain" <iain@mst.co.jp>)
List pgsql-admin
I've used LSI/MegaRAID controllers with the 2600 series servers with no
problems whatsoever in terms of performance.  With battery backed cache
the machine never went above 0.05 load factor in production, and could
handle pgbench with 300 to 600 tps under various settings.  Loading a 10
gig data set with fks and indexes took about 5 or 6 minutes.

On Mon, 2004-12-13 at 19:32, Iain wrote:
> Hi Ericson,
>
> I'm planning on using the onboard LSI SCSI controller, and have read alot
> about poor IO performance on Dells using LSI. Then  again, most of the talk
> about Adaptec hasn't been all that complimentary either as I saw it ;-) It
> seems that there is more to it than the name of the chip vendor. I havn't
> heard anything bad about the Tyan opteron based boards in any configuration
> yet though.
>
> Thanks for your feedback,
> regards
> Iain
>
>
> ----- Original Message -----
> From: "Ericson Smith" <eric@did-it.com>
> To: <pgsql-admin@postgresql.org>
> Sent: Tuesday, December 14, 2004 12:11 AM
> Subject: Re: [ADMIN] Tyan Thunder MB for postgres server
>
>
> > We use that exact configuration right now, except with an Adaptec card
> > and more RAM.
> >
> > We used RHEL 3.0, then switched to Fedora core 2 64Bit as a test, since
> > this server was since placed into standby duties. Well, we needed to use
> > the server when the main server went into maintenance recently, and it
> > worked fantastically well with Fedora 64Bit.
> >
> > You want to get the RPM source package for Postgresql and build the
> > RPM's instead of installing from source. This method builds the binary
> > RPM's for your platform which you can then install normally afterwards.
> >
> > Warmest regards,
> > Ericson Smith
> > Tracking Specialist/DBA
> > +-----------------------+------------------------------+
> > | http://www.did-it.com | Need help tracking your paid |
> > | eric@did-it.com       | search campaigns?            |
> > | 516-255-0500          |        - Help is on the way! |
> > +-----------------------+------------------------------+
> >
> >
> >
> > Iain wrote:
> >
> >> Hi All,
> >>
> >> I've read a fair bit in these lists about server configurations, and
> >> have come to some conclusions as to the kind of system that I want to
> >> build. However, I would like to hear from anyone with specific
> >> experience of this config. before I go ahead and buy it:
> >>
> >> The system is based on a Tyan Thunder K8S motherboard, dual opterons
> >> and 4GB RAM, and the LSI dual channel raid option. OS will be RHEL AS
> >> 3 for AMD64
> >>
> >> The Tyan/opteron options seems tobe quite popular as a postgres
> >> server, but I'm not sure how many people are doing it all 64 bit, so
> >> my specific areas of concern at the moment are:
> >>
> >> 1. 64bit linux driver support - how is it?
> >>
> >> 2. Is there a postgres 7.4.6 package available for this (ie AMD64) or
> >> will I have to compile it myself?
> >>
> >> Personally, I don't mind compiling it myself - have done it many
> >> times, but since I have to write instructions for the system to be
> >> completely re-built in the case of a failure, I'd rather go with
> >> widely available packages as much as possible.
> >>
> >> I hope to hear from you,
> >> regards
> >> Iain
> >>
> >>
> >>
> >>
> >>
> >>
> >> ---------------------------(end of broadcast)---------------------------
> >> TIP 9: the planner will ignore your desire to choose an index scan if
> >> your
> >> joining column's datatypes do not match
> >>
> >
>
>
> --------------------------------------------------------------------------------
>
>
> >
> > ---------------------------(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 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

pgsql-admin by date:

Previous
From: William Yu
Date:
Subject: Re: Tyan Thunder MB for postgres server
Next
From: Mário Gamito
Date:
Subject: Bind PostgreSQL to a specific IP