pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Francisco Reyes <lists@stringsutils.com>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Pgsql performance <pgsql-performance@postgresql.org>
Subject: Re: 10K vs 15k rpm for analytics
Date: Tue, 02 Mar 2010 17:04:02 -0500
Message-ID: <cone.1267567442.11139.32557.1000@shelca> (raw)
References: <cone.1267562557.293175.32557.1000@shelca>
	<dcc563d11003021312k57e9c558n177e10ad16ab32b1@mail.gmail.com>
	<cone.1267565429.453229.32557.1000@shelca>
	<dcc563d11003021347h52f94812jf75b5937937a9ed4@mail.gmail.com>

Scott Marlowe writes:

> Have you tried short stroking the drives to see how they compare then?
>  Or is the reduced primary storage not a valid path here?

No, have not tried it. By the time I got the machine we needed it in 
production so could not test anything.

When the 2 new machines come I  should hopefully have time to try a few 
strategies, including RAID0, to see what is the best setup for our needs.
  
> RAID-10 of those to read at somewhere in or just past the gig per
> second range with a fast pcie (x8 or x16 or so) controller.

Thanks for the info. Contacted the vendor to see what pcie speed is the 
controller connected to, specially since we are considering getting 2 more 
machines from them.

> drives equals the 24 10k drives you're looking at now.  I can write at
> about 300 to 350 Megs a second on a slower Areca 12xx series
> controller and 8 2TB Western Digital Green drives, which aren't even

How about read spead?



view thread (47+ messages)  latest in thread

Message-ID: <cone.1267567442.11139.32557.1000@shelca>
Permalink:  ../cone.1267567442.11139.32557.1000@shelca/
Also on:    postgresql.org/message-id/cone.1267567442.11139.32557.1000@shelca

 · 

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: lists@stringsutils.com, scott.marlowe@gmail.com
  Subject: Re: 10K vs 15k rpm for analytics
  In-Reply-To: <cone.1267567442.11139.32557.1000@shelca>

* 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