pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Greg Smith <greg@2ndquadrant.com>
To: Craig James <craig_james@emolecules.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Weird XFS WAL problem
Date: Thu, 03 Jun 2010 12:52:44 -0400
Message-ID: <4C07DDDC.6000003@2ndquadrant.com> (raw)
In-Reply-To: <4C06E994.2080905@emolecules.com>
References: <AANLkTikS_QvlkYfv5_hbsXFH4SsTh1nP_WoTwRqpUUcz@mail.gmail.com>
	<AANLkTikegoyBvJXhqZGLZyTwRVyBs4qCuCQ7d1Vntk4w@mail.gmail.com>
	<AANLkTikjkEvj2hG-D1CMu49PQXXbxHVzpXm9JbLWzMQo@mail.gmail.com>
	<AANLkTimtdk11hrWd-OpvXGLrh-4pukGd9eHEUemEM3OR@mail.gmail.com>
	<AANLkTinAhrwwwQKh6NrX-nnvcpxT1EFFlZrUxhaDB87C@mail.gmail.com>
	<AANLkTinuOUTbuke9FTMtwSObcZBio0uOS1ysWrqFyK3t@mail.gmail.com>
	<4C06E994.2080905@emolecules.com>

Craig James wrote:
> I'm testing/tuning a new midsize server and ran into an inexplicable 
> problem.  With an RAID10 drive, when I move the WAL to a separate 
> RAID1 drive, TPS drops from over 1200 to less than 90!

Normally <100 TPS means that the write cache on the WAL drive volume is 
disabled (or set to write-through instead of write-back).  When things 
in this area get fishy, I will usually download sysbench and have it 
specifically test how many fsync calls can happen per second.  
http://projects.2ndquadrant.com/talks , "Database Hardware 
Benchmarking", page 28 has an example of the right incantation for that.

Also, make sure you run 3ware's utilities and confirm all the disks have 
finished their initialization and verification stages.  If you just 
adjusted disk layout that and immediate launched into benchmarks, those 
are useless until the background cleanup is done.

-- 
Greg Smith  2ndQuadrant US  Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com   www.2ndQuadrant.us




view thread (25+ messages)  latest in thread

Message-ID: <4C07DDDC.6000003@2ndquadrant.com>
Permalink:  ../4C07DDDC.6000003@2ndquadrant.com/
Also on:    postgresql.org/message-id/4C07DDDC.6000003@2ndquadrant.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: greg@2ndquadrant.com, craig_james@emolecules.com
  Subject: Re: Weird XFS WAL problem
  In-Reply-To: <4C07DDDC.6000003@2ndquadrant.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox