Re: improving write performance for logging

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-performance@xxxxxxxxxxxxxx
Subject: Re: improving write performance for logging
From: Michael Stone <mstone+postgres@xxxxxxxxx>
Date: Fri, 06 Jan 2006 11:03:12 -0500
In-reply-to: <1136556006.31602.5.camel@xxxxxxxxxxxxxxxxxxxxxx>
Mail-followup-to: pgsql-performance@xxxxxxxxxxxxxx
References: <43BB0C5C.8020207@xxxxxxxxxxxx> <1136382865.24450.7.camel@xxxxxxxxxxxxxxxxxxxxxx> <7.0.1.0.2.20060104092139.01c37da0@xxxxxxxxxxxxx> <1136390438.24450.49.camel@xxxxxxxxxxxxxxxxxxxxxx> <20060106010822.GK43311@xxxxxxxxxxxxx> <1136556006.31602.5.camel@xxxxxxxxxxxxxxxxxxxxxx>
User-agent: Mutt/1.5.11

On Fri, Jan 06, 2006 at 09:00:06AM -0500, Ian Westmacott wrote:

We use RAID50 instead of RAID0 for the tables for some fault-tolerance.
We use RAID0 for the WAL for performance.

I'm missing the implication of the question...


If you have the WAL on RAID 0 you have no fault tolerance, regardless of
what level you use for the tables.

Mike Stone

References:
- improving write performance for logging application
  - From: Steve Eckmann
- Re: improving write performance for logging application
  - From: Ian Westmacott
- Re: improving write performance for logging
  - From: Ron
- Re: improving write performance for logging
  - From: Ian Westmacott
- Re: improving write performance for logging
  - From: Jim C. Nasby
- Re: improving write performance for logging
  - From: Ian Westmacott

Prev by Date: Re: help tuning queries on large database
Next by Date: Re: help tuning queries on large database
Previous by thread: Re: improving write performance for logging
Next by thread: Avoiding cartesian product
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux