Re: Re: Faster CREATE DATABASE by delaying fsync

Поиск
Список
Период
Сортировка
От Florian Weimer
Тема Re: Re: Faster CREATE DATABASE by delaying fsync
Дата
Msg-id 87wryfpnuv.fsf@mid.deneb.enyo.de
обсуждение исходный текст
Ответ на Re: Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb)  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Re: Faster CREATE DATABASE by delaying fsync
Список pgsql-hackers
* Tom Lane:

>> Which options would that be? I am not aware that there any for any of the 
>> recent linux filesystems.
>
> Shouldn't journaling of metadata be sufficient?

You also need to enforce ordering between the directory update and the
file update.  The file metadata is flushed with fsync(), but the
directory isn't.  On some systems, all directory operations are
synchronous, but not on Linux.


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: LISTEN/NOTIFY versus encoding conversion
Следующее
От: Mark Mielke
Дата:
Сообщение: Re: Re: Faster CREATE DATABASE by delaying fsync