| From: | Steve Francis <sfrancis(at)logicmonitor(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Pre-Allocate tablespace on disk |
| Date: | 2010-11-19 19:42:44 |
| Message-ID: | 4CE6D334.6080005@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">
Not only that, but if your "disk" is really a bunch of disks behind
a hardware RAID controller, or SAN, or iSCSI or NFS server - what is
contiguous for the OS may not be contiguous on the physical drives
(and vice versa). <br>
Which is why performance can (but may not) improve if you disable
linux kernel IO schedulers that attempt to optimize blocks to be
sequential.<br>
<br>
<br>
<br>
On 11/19/2010 5:01 AM, Florian Weimer wrote:
<blockquote cite="mid:82zkt55ux4(dot)fsf(at)mid(dot)bfk(dot)de" type="cite">
<pre wrap="">* Chris Ruprecht:
</pre>
<blockquote type="cite">
<pre wrap="">Other database that I have worked with before and that I'm still
working with, allow you to pre-allocate disk space so you get huge
chunks of contiguous space at one, which has major impacts on
database performance.
</pre>
</blockquote>
<pre wrap="">
PostgreSQL's write patterns do not trigger significant fragmentation
with most file systems, even when other database systems (Oracle
Berkeley DB comes to my mind) would create heavily fragmented files.
</pre>
</blockquote>
<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"> <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> <br>
</p>
</div>
</div>
</body>
</html>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 2.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lou Picciano | 2010-11-20 00:22:13 | Building pl/plsh - Shell scripting from PG v9.0.1? |
| Previous Message | Florian Weimer | 2010-11-19 13:01:43 | Re: Pre-Allocate tablespace on disk |