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

Re: moving pg_xlog -- yeah, it's worth it!

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: Jesper Krogh <jesper(at)krogh(dot)cc>, pgsql-performance(at)postgresql(dot)org
Subject: Re: moving pg_xlog -- yeah, it's worth it!
Date: 2010-02-11 17:57:52
Message-ID: 20100211175752.GB3145@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-performance
Kevin Grittner wrote:

> Another example of why I shouldn't trust my memory.  Per the
> hardware tech:
>  
>  
> OS:      /dev/sda   is RAID1  -  2  x  2.5" 15k SAS disk
> pg_xlog: /dev/sdb   is RAID1  -  2  x  2.5" 15k SAS disk
>  
> These reside on a ServeRAID-MR10k controller with 256MB BB cache.
>  
>  
> data:    /dev/sdc   is RAID5  -  30 x 3.5" 15k SAS disk
>  
> These reside on the DS3200 disk subsystem with 512MB BB cache per
> controller and redundant drive loops.

Hmm, so maybe the performance benefit is not from it being on a separate
array, but from it being RAID1 instead of RAID5?

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

pgsql-performance by date

Next:From: Aidan Van DykDate: 2010-02-11 18:04:21
Subject: Re: moving pg_xlog -- yeah, it's worth it!
Previous:From: Kevin GrittnerDate: 2010-02-11 17:48:37
Subject: Re: moving pg_xlog -- yeah, it's worth it!

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