On 2024-06-10 Mo 12:21, Tom Lane wrote:
Magnus Hagander <mag...@hagander.net> writes:
On Mon, Jun 10, 2024 at 5:03 PM Nathan Bossart <nathandboss...@gmail.com>
wrote:
Is there a particular advantage to that approach as opposed to just using
"directory" mode for everything?
A gazillion files to deal with? Much easier to work with individual custom
files if you're moving databases around and things like that.
Much easier to monitor eg sizes/dates if you're using it for backups.
You can always tar up the directory tree after-the-fact if you want
one file. Sure, that step's not parallelized, but I think we'd need
some non-parallelized copying to create such a file anyway.
Yeah.
I think I can probably allow for Magnus' suggestion fairly easily, but
if I have to choose I'm going to go for the format that can be produced
with the maximum parallelism.
cheers
andrew
--
Andrew Dunstan
EDB: https://www.enterprisedb.com