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

raid10 write performance

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: raid10 write performance
Date: 2010-06-22 09:31:08
Message-ID: AANLkTinbKXufTYhNuhNaOW2kWM-simIL3dg0uFX7Ij6g@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
Hi folks,

is there a general problem with raid10 performance postgresql on it?
We see very low performance on writes (2-3x slower than on less
performant servers). I wonder if it is solely problem of raid10
configuration, or if it is postgresql's thing.

Would moving WAL dir to separate disk help potentially ?

We're running centos 5.4, and server config is:

x3550 M2, xeon 4c e5530 2.4ghz , 6GB of ram
disks: ibm 300gb 2.5 SAS

raid: serveRAID M5014 SAS/SATA controller

strip size is the default 128k


thanks.

-- 
GJ

Responses

pgsql-performance by date

Next:From: Russell SmithDate: 2010-06-22 09:45:19
Subject: Re: Low perfomance SUM and Group by large databse
Previous:From: Robert HaasDate: 2010-06-21 22:14:39
Subject: Re: PostgreSQL as a local in-memory cache

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