Re: initdb and fsync

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: initdb and fsync
Дата
Msg-id 1331698983.6425.108.camel@jdavis
обсуждение исходный текст
Ответ на Re: initdb and fsync  (Andres Freund <andres@anarazel.de>)
Ответы Re: initdb and fsync
Список pgsql-hackers
On Tue, 2012-03-13 at 09:42 +0100, Andres Freund wrote:
> for recursively everything in dir:
>    posix_fadvise(fd, POSIX_FADV_DONTNEED);
>
> for recursively everything in dir:
>    fsync(fd);

Wow, that made a huge difference!

  no sync:      ~ 1.0s
  sync:         ~10.0s
  fadvise+sync: ~ 1.3s

Patch attached.

Now I feel much better about it. Most people will either have fadvise, a
write cache (rightly or wrongly), or actually need the sync. Those that
have none of those can use -N.

Regards,
    Jeff Davis

Вложения

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

Предыдущее
От: Euler Taveira
Дата:
Сообщение: Re: pg_upgrade and statistics
Следующее
От: Joachim Wieland
Дата:
Сообщение: Re: patch for parallel pg_dump