X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 3C0DB11F65E4 for ; Thu, 6 Apr 2006 18:55:36 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 47653-05 for ; Thu, 6 Apr 2006 18:55:31 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from brmea-mail-3.sun.com (brmea-mail-3.Sun.COM [192.18.98.34]) by postgresql.org (Postfix) with ESMTP id 1C19211F65DA for ; Thu, 6 Apr 2006 18:55:31 -0300 (ADT) Received: from fe-amer-01.sun.com ([192.18.108.175]) by brmea-mail-3.sun.com (8.12.10/8.12.9) with ESMTP id k36LtVJO002746 for ; Thu, 6 Apr 2006 15:55:31 -0600 (MDT) Received: from conversion-daemon.mail-amer.sun.com by mail-amer.sun.com (Sun Java System Messaging Server 6.2-4.02 (built Sep 9 2005)) id <0IXB00101M4VKG00@mail-amer.sun.com> (original mail from J.K.Shah@Sun.COM) for pgsql-performance@postgresql.org; Thu, 06 Apr 2006 15:55:31 -0600 (MDT) Received: from [129.148.9.81] by mail-amer.sun.com (Sun Java System Messaging Server 6.2-4.02 (built Sep 9 2005)) with ESMTPSA id <0IXB00E3QM8IL8Y2@mail-amer.sun.com>; Thu, 06 Apr 2006 15:55:31 -0600 (MDT) Date: Thu, 06 Apr 2006 17:55:30 -0400 From: "Jignesh K. Shah" Subject: Re: Sun Fire T2000 and PostgreSQL 8.1.3 In-reply-to: <443497AB.4000309@eclinic.com.au> To: Leigh Dyer Cc: Luke Lonergan , "Juan Casero (FL FLC)" , Josh Berkus , pgsql-performance@postgresql.org Message-id: <44358E52.4020706@sun.com> Organization: Sun Microsystems MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7BIT X-Accept-Language: en-us, en References: <443497AB.4000309@eclinic.com.au> User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050322) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200604/119 X-Sequence-Number: 18203 Hi Leigh inline comments Leigh Dyer wrote: > Luke Lonergan wrote: > >> Juan, > > We've got a Sun Fire V40z and it's quite a nice machine -- 6x 15krpm > drives, 4GB RAM, and a pair of Opteron 850s. This gives us more than > enough power now for what we need, but it's nice to know that we can > shoehorn a lot more RAM, and up it to eight CPU cores if needed. > > The newer Sun Opteron systems look nice too, but unless you're using > external storage, their little 2.5" hard drives may not be ideal. > Thats because Sun Fire V40z had write cache turned on while the 4200/4100 has the write cache turned off. There is a religious belief around the "write cache" on the disk in Sun :-) To really compare the performance, you have to turn on the write cache (I believe it was format -e and the cache option.. but that could have changed.. need to verify that again.. Same goes for T2000 SAS disks too.. Write cache is turned off on it so be careful before you compare benchmarks on internal drives :-) -Jignesh > Thanks > Leigh > >> >> - Luke >> >> >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 2: Don't 'kill -9' the postmaster >> > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: 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