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

Re: questions about disk configurations

From: Hubert depesz Lubaczewski <depesz(at)depesz(dot)pl>
To: Adrian 'Dagurashibanipal' von Bidder <avbidder(at)fortytwo(dot)ch>,pgsql-performance(at)postgresql(dot)org
Subject: Re: questions about disk configurations
Date: 2002-12-09 13:05:21
Message-ID: 20021209130521.GA4372@depesz.pl (view raw or flat)
Thread:
Lists: pgsql-performance
On Mon, Dec 09, 2002 at 01:01:58PM +0100, Adrian 'Dagurashibanipal' von Bidder wrote:
> A bit more data is needed before anybody can give you more help:
>  - what is your budget?
>  - how big will your databases be?
>  - what's the read/write ratio?

my question as for now is purely theoretical. i'm not asking about any
specific situation, but me may talk about medium sized web size. budget
is irrelevant (i'd like to talk *only* about harddrives, not memory,
architescure and so on).

>  - as you correctly said: distribute the load on many spindles. On a
> busy database, 4*20G is probably faster than 1*80G

as i said: i know that 3 disks are bettar than 1 (as for postgres
installation, because system data and swap should be on 4th disc - but
this is obvious).

> beyound this, experiences vary. RAID1 and RAID5 are rated differently by
> different people - and especially with RAID5 there are (I think) really
> performance differencies between the various products. RAID0 is fastest,
> of course, but you probably care for your data.

that's exactly what i'm asking about: which raid is best suited for
which data amongst out 3 sets (xlog, tables, indices). or maybe for some
types of data single disc is better than raid for some strange reason?
is it better to (when having 2 discs) setup raid 0/1 or to use tham
separatelly as xlog/tables?

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


In response to

Responses

pgsql-performance by date

Next:From: Bruce MomjianDate: 2002-12-09 18:09:31
Subject: Re: Speeding up aggregates
Previous:From: Rod TaylorDate: 2002-12-09 13:04:58
Subject: Re: is insertion and movement times are correlated to

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