Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 8B96F2E0097 for ; Thu, 3 Apr 2008 14:27:48 -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 59080-06 for ; Thu, 3 Apr 2008 14:27:36 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sca-es-mail-1.sun.com (sca-es-mail-1.Sun.COM [192.18.43.132]) by developer.postgresql.org (Postfix) with ESMTP id B781F2E0074 for ; Thu, 3 Apr 2008 14:27:37 -0300 (ADT) Received: from fe-sfbay-10.sun.com ([192.18.43.129]) by sca-es-mail-1.sun.com (8.13.7+Sun/8.12.9) with ESMTP id m33HRaJG025606 for ; Thu, 3 Apr 2008 10:27:36 -0700 (PDT) Received: from conversion-daemon.fe-sfbay-10.sun.com by fe-sfbay-10.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) id <0JYR00B01EKQY800@fe-sfbay-10.sun.com> (original mail from Robert.Lor@Sun.COM) for pgsql-admin@postgresql.org; Thu, 03 Apr 2008 10:27:36 -0700 (PDT) Received: from robert-lors-macbook-pro-15.local ([76.203.242.247]) by fe-sfbay-10.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) with ESMTPSA id <0JYR005SHF5ZGG00@fe-sfbay-10.sun.com>; Thu, 03 Apr 2008 10:27:36 -0700 (PDT) Date: Thu, 03 Apr 2008 12:27:35 -0500 From: Robert Lor Subject: Re: Postgres and SUN In-reply-to: <46F5921DF52F6E40860287B30CADADC77767B6@EROS.nexus-ag.com> To: =?UTF-8?B?VGhvbWFzIEJyw6R1dGlnYW0=?= Cc: pgsql-admin@postgresql.org, "Jignesh K. Shah" Message-id: <47F51387.9050409@sun.com> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=UTF-8 Content-transfer-encoding: 8BIT References: <46F5921DF52F6E40860287B30CADADC7776709@EROS.nexus-ag.com> <200804011204.10351@zmi.at> <46F5921DF52F6E40860287B30CADADC7776728@EROS.nexus-ag.com> <200804011454.16613@zmi.at> <46F5921DF52F6E40860287B30CADADC77767B6@EROS.nexus-ag.com> User-Agent: Thunderbird 2.0.0.6 (Macintosh/20070728) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/31 X-Sequence-Number: 28795 Thomas, Thomas Bräutigam 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. > 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-20070703-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