Skip site navigation (1) Skip section navigation (2)

Re: Tuning scenarios (was Changing the default

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Tuning scenarios (was Changing the default
Date: 2003-02-20 23:49:28
Message-ID: 20030220184928.D30080@mail.libertyrms.com (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-hackerspgsql-performance
On Thu, Feb 20, 2003 at 06:35:44PM -0500, Robert Treat wrote:
> Do you know how well those numbers hold up under scsi and/ or raid based
> system? (I'd assume anyone doing serious work would run scsi)

On some Sun E450s we have used, the machines are unusable for any
load with xlog on the same disk (in the case I'm remembering, these
are older 5400 RPM drives).  Moving the xlog changed us for
<hazymemory>something like 10tps to something like 30tps</hazymemory>
in one seat-of-the-pants case.  Sorry I can't be more specific.

> ok (playing a bit of devil's advocate here), but you have two possible
> points of failure, the data disk and the xlog disk. If either one goes,
> your in trouble. OTOH if you put the OS disk on one drive and it goes,
> your database and xlog are still safe on the other drive. 

If you're really worried about that, use RAID 1+0.

A

-- 
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info>                              M2P 2A8
                                         +1 416 646 3304 x110


In response to

pgsql-performance by date

Next:From: Christopher Kings-LynneDate: 2003-02-21 01:45:24
Subject: Re: cost and actual time
Previous:From: Robert TreatDate: 2003-02-20 23:35:44
Subject: Re: Tuning scenarios (was Changing the default

pgsql-hackers by date

Next:From: Josh BerkusDate: 2003-02-21 00:06:39
Subject: Re: request for sql3 compliance for the update command
Previous:From: Robert TreatDate: 2003-02-20 23:35:44
Subject: Re: Tuning scenarios (was Changing the default

pgsql-advocacy by date

Next:From: Bruno Wolff IIIDate: 2003-02-21 04:13:19
Subject: Can someone respond to LWN comment?
Previous:From: Robert TreatDate: 2003-02-20 23:35:44
Subject: Re: Tuning scenarios (was Changing the default

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group