Re: Best Linux filesystem for Postgres data store ?

From: Steve Francis <sfrancis(at)logicmonitor(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Best Linux filesystem for Postgres data store ?
Date: 2010-12-01 16:05:47
Message-ID: 4CF6725B.2050004@logicmonitor.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
On 12/1/2010 7:54 AM, Kevin Grittner wrote:
<blockquote cite="mid:4CF61B430200002500038009(at)gw(dot)wicourts(dot)gov"
type="cite"><br>
<pre wrap="">
Your RAID configuration and controllers will likely make a bigger
difference than your filesystem choices. Be sure to get good RAID
controllers with battery-backed (BBU) cache, configured for
write-back.
</pre>
</blockquote>
I agree that storage makes a bigger difference than filesystems in
most cases.<br>
Just wanted to jump in and say that testing with your workload is
really the only way to know things for sure. (Obviously, more
spindles implies more IOps, more cache implies faster writes...)<br>
But I have seen cases where a dell PERC RAID controller (not sure
that qualifies as "good") slowed things down when configured for
writeback with a write heavy workload. We noticed very spiky disk IO
rates on some database servers (we are monitoring company, so have
lots and lots of pretty graphs.)&nbsp; The controller seemed to accept a
bunch of writes quickly, then when full then try to pump them all to
disk, which took a non-trivial number of seconds. So we'd see the
interesting state of iostat reporting zero disk transactions per
second, but busy time = 100% and service time being hundreds of
millseconds.<br>
Switching to write through made things much faster overall. Not what
I expected.<br>
<br>
This was a PERC 5, so a few years ago. No doubt things have
improved, but the point is to test and monitor.<br>
<br>
<div class="moz-signature">-- <br>
<style type="text/css"> .sig, .sig a, .sig td { font: 12px Arial; color: DarkBlue; white-space: nowrap; vertical-align: top; text-align: left; } .sig img { border: 0; } .sig a { font: 11px Arial; } .sig .back { color: #ffffff; background-color: DarkBlue; text-decoration: none; } .sig .right { text-align: right; } .sig .border { border: 1px solid DarkBlue; margin:5px; border-collapse: collapse; } .sig .bottom { vertical-align:bottom } .sig p { clear:both; margin:2px; } </style>
<div class="sig">
<table class="border">
<tbody>
<tr>
<td class="back">&nbsp;<b>Steve Francis</b></td>
<td class="back" style="width: 30px;"><br>
</td>
<td class="back" style="text-align: right;"><b>LogicMonitor
LLC</b></td>
</tr>
<tr>
<td><br>
</td>
<td><br>
</td>
<td class="right"><br>
</td>
</tr>
<tr>
<td class="bottom"><a class="moz-txt-link-abbreviated" href="mailto:sfrancis(at)logicmonitor(dot)com">sfrancis(at)logicmonitor(dot)com</a><br>
<a target="_blank" href="http://www.logicmonitor.com">www.logicmonitor.com</a></td>
<td><br>
</td>
<td class="bottom" style="text-align: right;"> Ph: 1 888
41 LOGIC x500<br>
Ph: 1 805 698 0770</td>
</tr>
</tbody>
</table>
<p>&nbsp; <br>
</p>
</div>
</div>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 3.4 KB

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ray Stell 2010-12-01 16:08:39 Re: Best Linux filesystem for Postgres data store ?
Previous Message Anibal Acosta 2010-12-01 15:58:15 How to recover a postgres installation from files