Re: COPY TO BLACKHOLE / pg_dump -j -Fb

From: ahmed <gouda0x(at)gmail(dot)com>
To: Jakub Wartak <jakub(dot)wartak(at)enterprisedb(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: COPY TO BLACKHOLE / pg_dump -j -Fb
Date: 2026-07-29 14:09:16
Message-ID: CAFTkQVK0uaGV=tL2EtjWrCY3Rz7FRHLUegn4EdG4VKRN6Yv=YQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Jakub, The use case that this feature addresses is interesting, but the
proposed implementation feels a bit ad-hoc to us: 1. `COPY ... TO ...`
implies moving data from one place to another. Having a `BLACKHOLE`
destination whose purpose is to check for data corruption seems
counter-intuitive. 2. The argument to `pg_dump --format=...` specifies an
archive format. A `blackhole` archive format and the `archBlackhole` entry
in the `ArchiveFormat` enum in the `pg_dump` code also seem ad-hoc and
counter-intuitive, because nothing is actually being archived. For those
reasons, I don't think `COPY` or `pg_dump` is the right place to support
this use case. Perhaps this needs a new command, but that might
overcomplicate things. In that case, I would prefer to leave things as they
are. Regards, Ahmed & Miłosz

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message ayoub.kazar 2026-07-29 14:11:39 Remove unused headers in rewriteGraphTable.c
Previous Message Denis Smirnov 2026-07-29 14:02:35 Re: Batching in executor