From: John Allgood <john@turbocorp.com>
To: pgsql-performance@postgresql.org
To: john@arbash-meinel.com
Subject: Peformance Tuning Opterons/ Hard Disk Layout
Date: Thu, 24 Feb 2005 13:31:38 -0500
Message-ID: <421E1D8A.8050203@turbocorp.com> (raw)
Hello Again
In the below statement you mention putting each database on its own raid
mirror.
"However, sticking with your arrangement, it would seem that you might be
able to get some extra performance if each database is on it's own raid,
since you are fairly likely to have 2 transactions occuring at the same
time, that don't affect eachother (since you wouldn't have any foreign
keys, etc on 2 separate databases.)"
That would take alot of disk drives to accomplish. I was thinking maybe
putting three or four databases on each raid and dividing the heaviest
used databases on each mirrored set. And for each of these sets have its
own mirror for pg_xlog. My question is what is the best way to setup
postgres databases on different disks. I have setup multiple postmasters
on this system as a test. The only problem was configuring each
databases "ie postgresql.conf, pg_hba.conf". Is there anyway in
postgres to have everything in one cluster and have it seperated onto
multiple drives. Here is a example of what is was thinking about.
MIRROR1 - Database Group 1
MIRROR2 - pg_xlog for database group 1
MIRROR3 - Database Group 2
MIRROR4 - pg_xlog for database group 2
MIRROR5 - Database Group 3
MIRROR6 - pg_xlog for database group 3
This will take about 12 disk drives. I have a 14 bay Storage Bay I can
use two of the drives for hotspare's.
Thanks
John Allgood - ESC
Systems Administrator
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: john@turbocorp.com, john@arbash-meinel.com
Subject: Re: Peformance Tuning Opterons/ Hard Disk Layout
In-Reply-To: <421E1D8A.8050203@turbocorp.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