Русский

Re: improving write performance for logging

thread

List

Post date

Sort by

From:	Michael Stone
Subject:	Re: improving write performance for logging
Date:	January 7, 2006 , 17:28:11
Msg-id:	20060106160311.GH32630@mathom.us (view: Whole thread, Raw)
In response to:	Re: improving write performance for logging (Ian Westmacott)
List:	pgsql-performance

Tree view

Tree view

improving write performance for logging application (Steve Eckmann, 03 January 2006, 22:49:35 )
Re: improving write performance for logging application (Tom Lane, 03 January 2006, 23:00:13 )
Re: improving write performance for logging application (dlang, 03 January 2006, 23:13:58 )
Re: improving write performance for logging application (Steve Eckmann, 04 January 2006, 13:13:21 )
Re: improving write performance for logging application (Steve Eckmann, 04 January 2006, 13:00:21 )
Re: improving write performance for logging application (Tom Lane, 04 January 2006, 14:39:28 )
Re: improving write performance for logging application (Steve Eckmann, 04 January 2006, 23:16:53 )
Re: improving write performance for logging application ("Steinar H. Gunderson", 03 January 2006, 23:06:02 )
Re: improving write performance for logging application (Steve Eckmann, 04 January 2006, 13:08:39 )
Re: improving write performance for logging application (Kelly Burkhart, 04 January 2006, 14:40:29 )
Re: improving write performance for logging application (Steve Eckmann, 04 January 2006, 23:19:15 )
Re: improving write performance for logging application (Ian Westmacott, 04 January 2006, 12:54:26 )
Re: improving write performance for logging application (Steve Eckmann, 04 January 2006, 13:16:36 )
Re: improving write performance for logging (Ron, 04 January 2006, 13:29:04 )
Re: improving write performance for logging (Ian Westmacott, 04 January 2006, 15:00:42 )
Re: improving write performance for logging ("Jim C. Nasby", 06 January 2006, 00:08:23 )
Re: improving write performance for logging (Ian Westmacott, 06 January 2006, 13:00:13 )
Re: improving write performance for logging ("Jim C. Nasby", 06 January 2006, 15:37:35 )
Re: improving write performance for logging (Ian Westmacott, 06 January 2006, 18:03:01 )
Re: improving write performance for logging (Tom Lane, 06 January 2006, 19:27:50 )
Re: improving write performance for logging (Michael Stone, 07 January 2006, 17:28: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

pgsql-performance by date:

From: Michael Stone
Date: 07 January 2006, 11:28:11
Subject: Re: improving write performance for logging

From: "Luke Lonergan"
Date: 08 January 2006, 11:42:44
Subject: Re: help tuning queries on large database