Re: [PoC PATCH] Parallel dump to /dev/null - Mailing list pgsql-hackers

From Andrey Borodin
Subject Re: [PoC PATCH] Parallel dump to /dev/null
Date
Msg-id 21A17278-81A8-480F-886C-05D89340918B@yandex-team.ru
Whole thread Raw
In response to Re: [PoC PATCH] Parallel dump to /dev/null  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: [PoC PATCH] Parallel dump to /dev/null  (Vladimir Borodin <root@simply.name>)
List 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 by date:

Previous
From: Andres Freund
Date:
Subject: Re: JIT compiling with LLVM v9.0
Next
From: Etsuro Fujita
Date:
Subject: Re: [HACKERS] Add support for tuple routing to foreign partitions