Re: pg_fallocate

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: pg_fallocate
Дата
Msg-id CA+Tgmob5UhY0OdnvDFoHqGPuf4HejLdiMMd-jwO5voZioBtzyQ@mail.gmail.com
обсуждение исходный текст
Ответ на pg_fallocate  (Mitsumasa KONDO <kondo.mitsumasa@gmail.com>)
Список pgsql-hackers
On Thu, Oct 31, 2013 at 9:16 AM, Mitsumasa KONDO
<kondo.mitsumasa@gmail.com> wrote:
> 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:-)

Our last attempts to improve performance in this area died in a fire
when it turned out that code that should have been an improvement fell
down over inexplicable ext4 behavior.  I think, therefore, that
extensive benchmarking of this or any other proposed approach is
absolutely essential.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: How can I build OSSP UUID support on Windows to avoid duplicate UUIDs?
Следующее
От: Garick Hamlin
Дата:
Сообщение: Re: How can I build OSSP UUID support on Windows to avoid duplicate UUIDs?