pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Gene <genekhart@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: Areca 1260 Performance
Date: Thu, 7 Dec 2006 11:02:27 -0500
Message-ID: <430d92a20612070802q3cffeaeav2cf40c999ebc712b@mail.gmail.com> (raw)
In-Reply-To: <457836A2.1040307@007Marketing.com>
References: <BEB285F8-0BD2-4524-BD46-B1D35E7EFBEB@clickspace.com>
	<E1Gs3lS-0006i3-0D@elasmtp-banded.atl.sa.earthlink.net>
	<D53AD272-BA48-4945-A47D-072E4E2DE1D7@clickspace.com>
	<663E7F7B-680B-42C2-BA6A-A237E95CDCEA@clickspace.com>
	<E1Gs69E-0002uv-92@elasmtp-scoter.atl.sa.earthlink.net>
	<205957AA-B783-4CA7-B620-EFBF86D047EE@clickspace.com>
	<E1Gs75n-0008Nw-TZ@elasmtp-scoter.atl.sa.earthlink.net>
	<ACB833A1-05E8-4C02-9341-8899C2B5B57C@clickspace.com>
	<457836A2.1040307@007Marketing.com>

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

view thread (7+ messages)  latest in thread

Message-ID: <430d92a20612070802q3cffeaeav2cf40c999ebc712b@mail.gmail.com>
Permalink:  ../430d92a20612070802q3cffeaeav2cf40c999ebc712b@mail.gmail.com/
Also on:    postgresql.org/message-id/430d92a20612070802q3cffeaeav2cf40c999ebc712b@mail.gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: genekhart@gmail.com
  Subject: Re: Areca 1260 Performance
  In-Reply-To: <430d92a20612070802q3cffeaeav2cf40c999ebc712b@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox