Re: Hardware performance

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Hardware performance
Date: 2003-07-17 18:41:52
Message-ID: 20030717184152.GG479@libertyrms.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Jul 17, 2003 at 07:57:53AM -0700, Joe Conway wrote:
>
> As I said, I've never personally found it necessary to move WAL off to a
> different physical drive. What do you think is the best configuration

On our Solaris test boxes (where, alas, we do not have the luxury of
1/2 TB external RAID boxes :-( ), putting WAL on a disk of its own
yielded something like 30% improvement in throughput on high
transaciton volumes. So it's definitely important in some cases.

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

Browse pgsql-performance by date

  From Date Subject
Next Message Bill Moran 2003-07-17 18:51:10 Re: Relation of indices to ANALYZE
Previous Message Tom Lane 2003-07-17 18:27:16 Re: Relation of indices to ANALYZE