Re: Occasional Slow Commit

From: Peter Schuller <peter(dot)schuller(at)infidyne(dot)com>
To: David Rees <drees76(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Occasional Slow Commit
Date: 2008-11-06 10:21:47
Message-ID: 20081106102147.GB70379@hyperion.scode.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> I also found that my write cache was set to WriteThrough instead of
> WriteBack, defeating the purpose of having a BBU and that my secondary
> server apparently doesn't have a BBU on it. :-(

Note also that several RAID controllers will periodically drop the
write-back mode during battery capacity tests. If you care about
consistently/deterministically having full performance (with
white-backed battery protected caching), you probably want to confirm
your controller behavior here.

(I've seen this on at least LSI based controllers in Dell 2950:s, and
also on some 3wares.)

--
/ Peter Schuller

PGP userID: 0xE9758B7D or 'Peter Schuller <peter(dot)schuller(at)infidyne(dot)com>'
Key retrieval: Send an E-Mail to getpgpkey(at)scode(dot)org
E-Mail: peter(dot)schuller(at)infidyne(dot)com Web: http://www.scode.org

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message brahma tiwari 2008-11-06 10:45:02 server space increasing very fast but transaction are very low
Previous Message Peter Schuller 2008-11-06 10:19:18 Re: lru_multiplier and backend page write-outs