Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 94A3C9FA282 for ; Thu, 7 Dec 2006 12:03:07 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 90505-06 for ; Thu, 7 Dec 2006 12:03:01 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.184]) by postgresql.org (Postfix) with ESMTP id DB9479F9C9E for ; Thu, 7 Dec 2006 12:03:00 -0400 (AST) Received: by nf-out-0910.google.com with SMTP id x4so975275nfb for ; Thu, 07 Dec 2006 08:03:00 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:references; b=aap+zBg90LvJlm3ZuAeHlTQC4Fxuk4oX9vM8N4oVLP33CT+1hsAMqj8BmADeXYIuKYoKxgxoyMax//XXa4ixzzy+LXuIIlGNLTS2KV7n7Q6EdGKIb1sCG3CcdgIByRvlym6ryO5kmsq5d1J4CyxepxOwBzDxr0De4FhW0P2ek4E= Received: by 10.49.91.9 with SMTP id t9mr4218613nfl.1165507348071; Thu, 07 Dec 2006 08:02:28 -0800 (PST) Received: by 10.49.78.1 with HTTP; Thu, 7 Dec 2006 08:02:27 -0800 (PST) Message-ID: <430d92a20612070802q3cffeaeav2cf40c999ebc712b@mail.gmail.com> Date: Thu, 7 Dec 2006 11:02:27 -0500 From: Gene Reply-To: gene@sotech.us To: pgsql-performance@postgresql.org Subject: Re: Areca 1260 Performance In-Reply-To: <457836A2.1040307@007Marketing.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_142428_32934767.1165507347861" References: <663E7F7B-680B-42C2-BA6A-A237E95CDCEA@clickspace.com> <205957AA-B783-4CA7-B620-EFBF86D047EE@clickspace.com> <457836A2.1040307@007Marketing.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/177 X-Sequence-Number: 22233 ------=_Part_142428_32934767.1165507347861 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline I'm building a SuperServer 6035B server (16 scsi drives). My schema has basically two large tables (million+ per day) each which are partitioned daily, and queried independently of each other. Would you recommend a raid1 system partition and 14 drives in a raid 10 or should i create separate partitions/tablespaces for the two large tables and indexes? Thanks Gene On 12/7/06, Shane Ambler wrote: > > > >> One thing that is clear from what you've posted thus far is that you > >> are going to needmore HDs if you want to have any chance of fully > >> utilizing your Areca HW. > > Do you know off hand where I might find a chassis that can fit 24[+] > > drives? The last chassis we ordered was through Supermicro, and the > > largest they carry fits 16 drives. > > Chenbro has a 24 drive case - the largest I have seen. It fits the big > 4/8 cpu boards as well. > > http://www.chenbro.com/corporatesite/products_01features.php?serno=43 > > > -- > > Shane Ambler > pgSQL@007Marketing.com > > Get Sheeky @ http://Sheeky.Biz > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > -- Gene Hart cell: 443-604-2679 ------=_Part_142428_32934767.1165507347861 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline I'm building a SuperServer 6035B server (16 scsi drives). My schema has basically two large tables (million+ per day) each which are partitioned daily, and queried independently of each other. Would you recommend a raid1 system partition and 14 drives in a raid 10 or should i create separate partitions/tablespaces for the two large tables and indexes?

Thanks
Gene

On 12/7/06, Shane Ambler <pgsql@007marketing.com> wrote:

>> One thing that is clear from what you've posted thus far is that you
>> are going to needmore HDs if you want to have any chance of fully
>> utilizing your Areca HW.
> Do you know off hand where I might find a chassis that can fit 24[+]
> drives? The last chassis we ordered was through Supermicro, and the
> largest they carry fits 16 drives.

Chenbro has a 24 drive case - the largest I have seen. It fits the big
4/8 cpu boards as well.

http://www.chenbro.com/corporatesite/products_01features.php?serno=43


--

Shane Ambler
pgSQL@007Marketing.com

Get Sheeky @ http://Sheeky.Biz

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match



--
Gene Hart
cell: 443-604-2679 ------=_Part_142428_32934767.1165507347861--