Re: questions about disk configurations

From: Hubert depesz Lubaczewski <depesz(at)depesz(dot)pl>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: questions about disk configurations
Date: 2002-12-10 21:16:03
Message-ID: 20021210211603.GA22257@depesz.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

i'm replying to my own letter to gather all replies in one mail.

i got some replies. some of them are useful. some aren't really. i'm not
really sure how the usage can modify "what is best for some part of
database files".
can you explain me how comes that for some uses it's best
(performance-wise) to keep xlog's on straight disc, and tables on raid5
with lots' of disks, and for some other uses it's better to keep xlog on
raid0 and tables on raid 10?

anyway: what i understood is that usually the best (performance-wise),
would be to put:
xlog - separate - unraid'ed disk, or raid0
tables - any raid, but not raid 1
indices - any raid, but not raid 1

thanks for all replies.

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

Browse pgsql-performance by date

  From Date Subject
Next Message Ron Johnson 2002-12-10 23:13:35 Re: questions about disk configurations
Previous Message Hannu Krosing 2002-12-10 20:50:22 Re: Performance of multi-column index on INSERT