Re: fdatasync performance problem with large number of DB files

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема Re: fdatasync performance problem with large number of DB files
Дата
Msg-id 47abaf1d-4122-3fd0-c934-303da9ce1596@oss.nttdata.com
обсуждение исходный текст
Список pgsql-hackers

On 2021/03/17 12:02, Thomas Munro wrote:
> On Tue, Mar 16, 2021 at 9:10 PM Fujii Masao <masao.fujii@oss.nttdata.com> wrote:
>> Thanks for the patch!
>>
>> +        When set to <literal>fsync</literal>, which is the default,
>> +        <productname>PostgreSQL</productname> will recursively open and fsync
>> +        all files in the data directory before crash recovery begins.
>>
>> Isn't this a bit misleading? This may cause users to misunderstand that
>> such fsync can happen only in the case of crash recovery.
> 
> If I insert the following extra sentence after that one, is it better?
>   "This applies whenever starting a database cluster that did not shut
> down cleanly, including copies created with pg_basebackup."

Yes. Thanks!

Regards,

-- 
Fujii Masao
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION



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

Предыдущее
От: Fujii Masao
Дата:
Сообщение: Re: Get memory contexts of an arbitrary backend process
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: Detecting File Damage & Inconsistencies