pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: John Arbash Meinel <john@arbash-meinel.com>
To: John Allgood <john@turbocorp.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Peformance Tuning Opterons/ Hard Disk Layout
Date: Wed, 23 Feb 2005 15:01:55 -0600
Message-ID: <421CEF43.6030207@arbash-meinel.com> (raw)
In-Reply-To: <421CEA85.50506@turbocorp.com>
References: <421cca80.3da18bb5.6940.3b12@smtp.gmail.com>
	<21021.1109183848@sss.pgh.pa.us>
	<421CD668.7010503@turbocorp.com>
	<421CDD83.3070609@arbash-meinel.com>
	<421CE1FD.80003@turbocorp.com>
	<421CE699.1060300@arbash-meinel.com>
	<421CEA85.50506@turbocorp.com>

John Allgood wrote:

> Here is a summary about the cluster suite from redhat. All 9 databases
> will be on the primary server the secondary server I have is the
> failover. They don't actually share the partitions at the same time.
> When you have some type of failure the backup server takes over. Once
> you setup the hardware and install the clustering software. You then
> setup a service "ie postgres" and then you tell it what harddrive you
> will be using. /dev/sde1 and the clustering software takes care of
> starting and stopping the postgres database.
>
Okay, I misunderstood your hardware. So you actually only have 1
machine, with a second machine as a potential rollover. But all
transactions occur on the same hardware, even if is a separate
"database". I was thinking these were alternate machines.

So my first question is why are you partitioning into a separate
database, and then updating the master one at night. Since everything is
restricted to the same machine, why not just have everything performed
on the master?

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.)

But I think the basic OS RAID1, pg_xlog RAID10, database RAID10 is still
a good separation of disks. And probably would help you maximize your
throughput.

I can't say too much about how the Cluster failover stuff will work with
postgres. But as long as one is completely shutdown before the next is
started, and they are both running binary compatible versions of
postgres, it seems like it would be fine. Not much different from having
a second machine that is sitting turned off, which you turn on when the
first one fails.

John
=:->

Attachments:

  signature.asc (application/pgp-signature, 252B) download

view thread (23+ messages)  latest in thread

Message-ID: <421CEF43.6030207@arbash-meinel.com>
Permalink:  ../421CEF43.6030207@arbash-meinel.com/
Also on:    postgresql.org/message-id/421CEF43.6030207@arbash-meinel.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@arbash-meinel.com, john@turbocorp.com
  Subject: Re: Peformance Tuning Opterons/ Hard Disk Layout
  In-Reply-To: <421CEF43.6030207@arbash-meinel.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