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

Re: Pre-Allocate tablespace on disk

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 (view raw or flat)
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">&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: unknown_filename
Description: text/html (2.9 KB)

In response to

pgsql-admin by date

Next:From: Lou PiccianoDate: 2010-11-20 00:22:13
Subject: Building pl/plsh - Shell scripting from PG v9.0.1?
Previous:From: Florian WeimerDate: 2010-11-19 13:01:43
Subject: Re: Pre-Allocate tablespace on disk

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