Re: should frontend tools use syncfs() ?

Поиск
Список
Период
Сортировка
От Nathan Bossart
Тема Re: should frontend tools use syncfs() ?
Дата
Msg-id 20230731175138.GA432880@nathanxps13
обсуждение исходный текст
Ответ на Re: should frontend tools use syncfs() ?  (Nathan Bossart <nathandbossart@gmail.com>)
Ответы Re: should frontend tools use syncfs() ?  (Nathan Bossart <nathandbossart@gmail.com>)
Список pgsql-hackers
On Sat, Jul 29, 2023 at 02:40:10PM -0700, Nathan Bossart wrote:
> I was about to start a new thread, but I found this one with some good
> preliminary discussion.  I came to the same conclusion about introducing a
> new option instead of using syncfs() by default wherever it is available.
> The attached patch is still a work-in-progress, but it seems to behave as
> expected.  I began investigating this because I noticed that the
> sync-data-directory step on pg_upgrade takes quite a while when there are
> many files, and I am looking for ways to reduce the amount of downtime
> required for pg_upgrade.
> 
> The attached patch adds a new --sync-method option to the relevant frontend
> utilities, but I am not wedded to that name/approach.

Here is a new version of the patch with documentation updates and a couple
other small improvements.

-- 
Nathan Bossart
Amazon Web Services: https://aws.amazon.com

Вложения

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

Предыдущее
От: Joe Conway
Дата:
Сообщение: Re: pgsql: Fix search_path to a safe value during maintenance operations.
Следующее
От: Nathan Bossart
Дата:
Сообщение: Re: add timing information to pg_upgrade