Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Admin > Re: Handling la...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 8 of 10 Topic 4890 of 5419
Post > Topic >>

Re: Handling large volumes of data

by michael.monnerie@[EMAIL PROTECTED] (Michael Monnerie) Apr 8, 2008 at 09:24 PM

--nextPart1241037.Ls2WfBh3bK
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

On Dienstag, 8. April 2008 Johann Spies wrote:
> I have got 8x720G disks in a hardware raid 5 setup. It is a Dell 2950
> server. I am using an XFS-filesystem. =A0I am not certain about the
> speed of the hard disk, but we bought the fastest we could get.

720G looks like SATA disks, probably with "only" 7.200rpm. The Western=20
Digital Raptor with 10.000rpm are about twice as fast on random access.=20
Also, RAID5/6 are very,very slow when it comes to small disk *writes*.=20
Which is exactly what a db makes. Retry with RAID-10, and you'll see=20
the difference.

We've had 6 WD Raptors in RAID-6 on an Areca RAID, and changed it to 8x=20
Raptor RAID-10, that improved things.

mfg zmi
=2D-=20
// Michael Monnerie, Ing.BSc    -----      http://it-management.at
// Tel: 0676/846 914 666                      .network.your.ideas.
// PGP Key:         "curl -s http://zmi.at/zmi.asc
| gpg --im****t"
// Fingerprint: AC19 F9D5 36ED CD8A EF38  500E CE14 91F7 1C12 09B4
// Keyserver: www.keyserver.net                   Key-ID: 1C1209B4

--nextPart1241037.Ls2WfBh3bK
Content-Type: application/pgp-signature; name=signature.asc 
Content-Description: This is a digitally signed message part.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4-svn0 (GNU/Linux)

iD8DBQBH+8ZXzhSR9xwSCbQRAiLRAKCKfUr1f8L2O8ZNNP7EYkmNJvG3rQCfZA78
hQxE8XQ2RNXqfPTQpBXQ9AE=
=5g+d
-----END PGP SIGNATURE-----

--nextPart1241037.Ls2WfBh3bK--
 




 10 Posts in Topic:
Handling large volumes of data
jspies@[EMAIL PROTECTED]   2008-04-08 11:42:34 
Re: Handling large volumes of data
shoaibmir@[EMAIL PROTECTE  2008-04-08 19:49:04 
Re: Handling large volumes of data
postgresql@[EMAIL PROTECT  2008-04-08 11:55:00 
Re: Handling large volumes of data
jspies@[EMAIL PROTECTED]   2008-04-08 14:16:03 
Re: Handling large volumes of data
michael.monnerie@[EMAIL P  2008-04-08 12:01:14 
Re: Handling large volumes of data
jspies@[EMAIL PROTECTED]   2008-04-08 12:13:36 
Re: Handling large volumes of data
postgresql@[EMAIL PROTECT  2008-04-08 14:00:07 
Re: Handling large volumes of data
michael.monnerie@[EMAIL P  2008-04-08 21:24:07 
Re: Handling large volumes of data
ajs@[EMAIL PROTECTED] (A  2008-04-09 10:00:45 
Re: Handling large volumes of data
tsakai@[EMAIL PROTECTED]   2008-04-08 08:47:06 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Tue Oct 14 10:39:36 CDT 2008.