Re: Reduce the time required for a database recovery from archive. - Mailing list pgsql-hackers

From David Steele
Subject Re: Reduce the time required for a database recovery from archive.
Date
Msg-id d7391d83-dbca-6680-b51b-f2af99458cde@pgmasters.net
Whole thread Raw
In response to Re: Reduce the time required for a database recovery from archive.  (Andrey Borodin <x4mmm@yandex-team.ru>)
List 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 by date:

Previous
From: Andrey Borodin
Date:
Subject: Re: Reduce the time required for a database recovery from archive.
Next
From: Dmitry Dolgov
Date:
Subject: Re: pg_stat_statements and "IN" conditions