Skip site navigation (1) Skip section navigation (2)

questions about disk configurations

From: Hubert depesz Lubaczewski <depesz(at)depesz(dot)pl>
To: pgsql-performance(at)postgresql(dot)org
Subject: questions about disk configurations
Date: 2002-12-09 11:32:31
Message-ID: 20021209113231.GA1113@depesz.pl (view raw or flat)
Thread:
Lists: pgsql-performance
hi
i have a question about best harddisk configuration for postgresql
performance.
of course i know that:
- scsi is better than ide
- 2 disks are better than 1
- 3 disks are better than 2

i know that with 3 disks one should move xlog to one drive, index files
to second and tables to third.
that's clear.

but:
will making software raid on this discs provide performance increase or
decrease?
which raid (0,1,5,10?) is best for postgresql? maybe it differs when it
comes to different datatypes (i.e. raid "X" is best for indices, but "Y"
best for tables).

i'd like to know what are the options to store all this information
(xlog, indices and tables). what configurations are best, what medium
and what should be avoided at all cost.

hope you can help me, and sorry for my english.

depesz

-- 
hubert depesz lubaczewski                          http://www.depesz.pl/
------------------------------------------------------------------------
Mój Boże, spraw abym milczał, dopóki się nie upewnię,  że  naprawdę  mam
coś do powiedzenia.                                      (c) 1998 depesz


Responses

pgsql-performance by date

Next:From: Adrian 'Dagurashibanipal' von BidderDate: 2002-12-09 12:01:58
Subject: Re: questions about disk configurations
Previous:From: Hannu KrosingDate: 2002-12-09 10:16:01
Subject: Re: Speeding up aggregates

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group