pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (23+ messages)  latest in thread

Message-ID: <421E1D8A.8050203@turbocorp.com>
Permalink:  ../421E1D8A.8050203@turbocorp.com/
Also on:    postgresql.org/message-id/421E1D8A.8050203@turbocorp.com

 · 

reply

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