Re: [PoC PATCH] Parallel dump to /dev/null

Поиск
Список
Период
Сортировка
От Andrey Borodin
Тема Re: [PoC PATCH] Parallel dump to /dev/null
Дата
Msg-id 21A17278-81A8-480F-886C-05D89340918B@yandex-team.ru
обсуждение исходный текст
Ответ на Re: [PoC PATCH] Parallel dump to /dev/null  (Michael Paquier <michael.paquier@gmail.com>)
Ответы Re: [PoC PATCH] Parallel dump to /dev/null
Список pgsql-hackers
Hi!

Michael, thanks for the patch!

> 2 февр. 2018 г., в 9:22, Michael Paquier <michael.paquier@gmail.com> написал(а):
>
> On Thu, Feb 01, 2018 at 02:24:46PM +0100, Michael Banck wrote:
>> dumping a database to /dev/null via pg_dump is (AFAIK) one recommended
>> way to check for corruption.  However, dumping to /dev/null is currently
>> not supported in directory mode which makes it not possible to dump to
>> /dev/null in parallel.
>
> Do folks here think that speedups would be worth it?
I've seen backup verification via COPY TO to /dev/null in production. These copies were parallelized on the side of
verificationscript. 
Not sure this counts for feature or against it.

Best regards, Andrey Borodin.

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: JIT compiling with LLVM v9.0
Следующее
От: Etsuro Fujita
Дата:
Сообщение: Re: [HACKERS] Add support for tuple routing to foreign partitions