On 20/07/2023 16:51, Scott Ribe wrote:
Alsready tried to use --link and --jobs, but you cannot ommit the "select lo_unlink ...." for every rows containing datatype text in your database that the pg_* program creates in the export/dump file.
Terminology again, or are you conflating two different issues? pg_upgrade --link does not create a dump file.
why does pg_dump/pg_restore for every row in pg_largeobject a "select lo_unlink ...." this takes a lot of time