Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id C9AC62E0053 for ; Fri, 4 Apr 2008 04:47:52 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 53717-02 for ; Fri, 4 Apr 2008 04:47:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from typhon.nexustelecom.com (typhon.nexustelecom.com [212.203.104.229]) by developer.postgresql.org (Postfix) with ESMTP id E740A2E004C for ; Fri, 4 Apr 2008 04:47:49 -0300 (ADT) X-IronPort-AV: E=Sophos;i="4.25,603,1199660400"; d="scan'208";a="55726" Received: from unknown (HELO hermes.nexustelecom.com) ([172.29.1.4]) by typhon.nexustelecom.com with ESMTP; 04 Apr 2008 09:47:48 +0200 Received: from hermes.nexustelecom.com (localhost [127.0.0.1]) by hermes.nexustelecom.com (Postfix) with ESMTP id E07B9159F64; Fri, 4 Apr 2008 09:47:47 +0200 (CEST) Received: from EROS.nexus-ag.com (nexus-ag.com [172.29.2.99]) by hermes.nexustelecom.com (Postfix) with ESMTP id 90676159F63; Fri, 4 Apr 2008 09:47:30 +0200 (CEST) X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Subject: Re: Postgres and SUN Date: Fri, 4 Apr 2008 09:47:34 +0200 Message-ID: <46F5921DF52F6E40860287B30CADADC7776B1B@EROS.nexus-ag.com> In-Reply-To: <47F51387.9050409@sun.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [ADMIN] Postgres and SUN Thread-Index: AciVsAhaOl1dW2xCTCKWuVZjsULECQAd+rJw References: <46F5921DF52F6E40860287B30CADADC7776709@EROS.nexus-ag.com> <200804011204.10351@zmi.at> <46F5921DF52F6E40860287B30CADADC7776728@EROS.nexus-ag.com> <200804011454.16613@zmi.at> <46F5921DF52F6E40860287B30CADADC77767B6@EROS.nexus-ag.com> <47F51387.9050409@sun.com> From: =?iso-8859-1?Q?Thomas_Br=E4utigam?= To: Cc: , "Jignesh K. Shah" X-TBoneOriginalFrom: =?iso-8859-1?Q?Thomas_Br=E4utigam?= X-TBoneOriginalTo: X-TBoneOriginalCc: , "Jignesh K. Shah" X-TBoneDomainSigned: false X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.483 tagged_above=0 required=5 tests=AWL=0.483 X-Spam-Level: X-Archive-Number: 200804/37 X-Sequence-Number: 28801 Hi Robert=20 What do you think about the SUN T5120 or T5220 with a Postgres Database? Cheers Thomas -----Original Message----- From: Robert.Lor@Sun.COM [mailto:Robert.Lor@Sun.COM]=20 Sent: Donnerstag, 3. April 2008 19:28 To: Thomas Br=E4utigam Cc: pgsql-admin@postgresql.org; Jignesh K. Shah Subject: Re: [ADMIN] Postgres and SUN Thomas, Thomas Br=E4utigam wrote: > Hi Zmi, > > Okay thanks for that advice. Sorry its my first day on a mailing list. > > But do Postgres have a special recommendation which SUN equipment runs = perfect with a Postgres Database? > > A time for a query over 30 seconds I would say is to long. So the = machine should be fast enough to handle it in 10-20 Seconds. Price for = the Machine doesn't matter at all. The machine should just fit and can = handle this kinda huge database. > =20 Sun has published a benchmark on the Sun Fire T2000 Server and the = results are published here = http://www.spec.org/jAppServer2004/results/res2007q3/jAppServer2004-20070= 703-00073.html Jignesh has also done tests on the following AMD and Intel systems, and = I believe the results were quite good. http://www.sun.com/servers/entry/x4200/ http://www.sun.com/servers/x64/x4450/ Regards, -Robert