Re: PostgresNode::backup uses spread checkpoint?

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: PostgresNode::backup uses spread checkpoint?
Дата
Msg-id 20201020225518.GB1475@paquier.xyz
обсуждение исходный текст
Ответ на Re: PostgresNode::backup uses spread checkpoint?  (David Steele <david@pgmasters.net>)
Ответы Re: PostgresNode::backup uses spread checkpoint?  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
On Tue, Oct 20, 2020 at 11:13:34AM -0400, David Steele wrote:
> On 10/20/20 11:01 AM, Alvaro Herrera wrote:
>> I noticed a few days ago that method backup() in PostgresNode uses
>> pg_basebackup without specifying a checkpoint mode -- and the default is
>> a spread checkpoint, which may cause any tests that use that to take
>> slightly longer than the bare minimum.
>>
>> I propose to make it use a fast checkpoint, as per the attached.
>
> +1.

+1.

-   $self->host, '-p', $self->port, '--no-sync');
+   $self->host, '-p', $self->port, '-cfast', '--no-sync');

Some nits: I would recommend to use the long option name, and list
the option name and its value as two separate arguments of the
command.
--
Michael

Вложения

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: CREATE TABLE .. PARTITION OF fails to preserve tgenabled for inherited row triggers
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: pg_upgrade: fail early if a tablespace dir already exists for new cluster version