From: Vivek Khera <khera@kcilink.com>
To: pgsql-performance@postgresql.org
Subject: Re: Tuning PostgreSQL
Date: Tue, 29 Jul 2003 11:14:54 -0400
Message-ID: <x7smope55d.fsf@yertle.int.kciLink.com> (raw)
References: <Pine.LNX.4.33.0307221114390.19504-100000@css120.ihs.com>
<873cgvpylu.fsf@stark.dyndns.tv>
>>>>> "GS" == Greg Stark <gsstark@mit.edu> writes:
GS> "scott.marlowe" <scott.marlowe@ihs.com> writes:
GS> But you have to actually test your setup in practice to see if it
GS> hurts. A big data warehousing system will be faster under RAID5
GS> than under RAID1+0 because of the extra disks in the
GS> stripeset. The more disks in the stripeset the more bandwidth you
GS> get.
Anyone have ideas on 14 spindles? I just ordered a disk subsystem
with 14 high speed (U320 15kRPM) SCSI disks to hook up with a dell
PERC3/DC controller (only 128MB cache, though).
My plan was to do RAID10, but I think I'll play with RAID5 again and
see which gives me the best performance. Unfortunatly, it is
difficult to recreate the highly fragmented tables I have now (vacuum
full takes over 14 hours on one of the tables) so I'm not sure how to
best compare them.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera@kciLink.com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/
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: khera@kcilink.com
Subject: Re: Tuning PostgreSQL
In-Reply-To: <x7smope55d.fsf@yertle.int.kciLink.com>
* 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