From: Carlos Moreno <moreno_pg@mochima.com>
To: pgsql-performance@postgresql.org
Subject: Two hard drives --- what to do with them?
Date: Sat, 24 Feb 2007 22:39:09 -0500
Message-ID: <45E104DD.3080600@mochima.com> (raw)
In-Reply-To: <45E0A500.1010707@commandprompt.com>
References: <45DF3B15.1070609@3times25.net>
<200702231330.57014.josh@agliodbs.com>
<45DF5DA9.90002@commandprompt.com>
<45DF6154.5090205@3times25.net>
<1d4e0c10702231425ke37a732y36e241902fe0aa55@mail.gmail.com>
<45DF94BF.6050904@3times25.net>
<45E0A500.1010707@commandprompt.com>
Say that I have a dual-core processor (AMD64), with, say, 2GB of memory
to run PostgreSQL 8.2.3 on Fedora Core X.
I have the option to put two hard disks (SATA2, most likely); I'm
wondering
what would be the optimal configuration from the point of view of
performance.
I do have the option to configure it in RAID-0, but I'm sort of
reluctant; I think
there's the possibility that having two filesystems that can be accessed
truly
simultaneously can be more beneficial. The question is: does PostgreSQL
have separate, independent areas that require storage such that performance
would be noticeably boosted if the multiple storage operations could be
done
simultaneously?
Notice that even with RAID-0, the "twice the performance" may turn into
an illusion --- if the system requires access from "distant" areas of
the disk
("distant" as in many tracks apart), then the back-and-forth travelling of
the heads would take precedence over the doubled access speed ... Though
maybe it depends on whether accesses are in small chunks (in which case
the cache of the hard disks could take precedence).
Coming back to the option of two independent disks --- the thing is: if it
turns out that two independent disks are a better option, how should I
configure the system and the mount points? And how would I configure
PostgreSQL to take advantage of that?
Advice, anyone?
Thanks,
Carlos
--
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: moreno_pg@mochima.com
Subject: Re: Two hard drives --- what to do with them?
In-Reply-To: <45E104DD.3080600@mochima.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