Re: Reduce the time required for a database recovery from archive.

Поиск
Список
Период
Сортировка
От David Steele
Тема Re: Reduce the time required for a database recovery from archive.
Дата
Msg-id d7391d83-dbca-6680-b51b-f2af99458cde@pgmasters.net
обсуждение исходный текст
Ответ на Re: Reduce the time required for a database recovery from archive.  (Andrey Borodin <x4mmm@yandex-team.ru>)
Список pgsql-hackers
On 3/18/21 11:37 AM, Andrey Borodin wrote:
> 
> 
>> 18 марта 2021 г., в 20:04, David Steele <david@pgmasters.net> написал(а):
>> it would be nice to support an interface that simply says to the restore_command, "go get 1gb of WAL and write the
fileshere."
 
> 
> +1 to redesigning restore_command and archive_command.

Indeed, archive_command would benefit from the same treatment. The need 
to call archive_command for each WAL segment even when parallel 
processing is going on behind the scenes is a bottleneck.

Larger WAL segments sizes can be used to mitigate this issue but an 
improvement would be welcome.

Regards,
-- 
-David
david@pgmasters.net



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

Предыдущее
От: Andrey Borodin
Дата:
Сообщение: Re: Reduce the time required for a database recovery from archive.
Следующее
От: Dmitry Dolgov
Дата:
Сообщение: Re: pg_stat_statements and "IN" conditions