Postgres Pro
Downloads
Home   >   mailing lists

pg_fallocate - Mailing list pgsql-hackers

From Mitsumasa KONDO
Subject pg_fallocate
Date
Msg-id CADupcHW1POmSuNoNMdVaWLTq-a3X_A3ZQMuSjHs4rCexiPgxAQ@mail.gmail.com
Whole thread Raw
Responses Re: pg_fallocate  (Robert Haas <robertmhaas@gmail.com>)
Re: pg_fallocate  (Peter Eisentraut <peter_e@gmx.net>)
Re: pg_fallocate  (Oskari Saarenmaa <os@ohmu.fi>)
List pgsql-hackers
Tree view
Hi,

@font-face { font-family: "Times"; }@font-face { font-family: "ＭＳ 明朝"; }@font-face { font-family: "Century"; }@font-face { font-family: "Century"; }@font-face { font-family: "@ＭＳ 明朝"; }p.MsoNormal, li.MsoNormal, div.MsoNormal { margin: 0mm 0mm 0.0001pt; text-align: justify; font-size: 12pt; font-family: Century; }.MsoChpDefault { font-family: Century; }div.WordSection1 { page: WordSec@font-face { font-family: "Times"; }@font-face { font-family: "ＭＳ 明朝"; }@font-face { font-family: "Century"; }@font-face { font-family: "Cambria Math"; }@font-face { font-family: "@ＭＳ 明朝"; }p.MsoNormal, li.MsoNormal, div.MsoNormal { margin: 0mm 0mm 0.0001pt; text-align: justify; font-size: 12pt; font-family: Century; }.MsoChpDefault { font-family: Century; }div.WordSection1 { page: WordSection1; }I'l like to add fallocate() system call to improve sequential read/write peformance. fallocate() system call is different from posix_fallocate() that is zero-fille algorithm to reserve continues disk space. fallocate() is almost less overhead alogotithm to reserve continues disk space than posix_fallocate().

It will be needed by sorted checkpoint and more faster vacuum command in near the future.


If you get more detail information, please see linux manual.

I go sight seeing in Dublin with Ishii-san now:-)

 

Regards,

--

Mitsumasa KONDO

NTT Open Source Software

Attachment

pgsql-hackers by date:

Previous
From: "MauMau"
Date:
Subject: Re: How can I build OSSP UUID support on Windows to avoid duplicate UUIDs?
Next
From: Peter Eisentraut
Date:
Subject: Re: How can I build OSSP UUID support on Windows to avoid duplicate UUIDs?