On Thu, 2025-03-20 at 23:48 +0100, Dimitrios Apostolou wrote:
> Performance issues: (important as my db size is >5TB)
>
> * WAL writes: I didn't manage to avoid writing to the WAL, despite having
> setting wal_level=minimal. I even wrote my own function to ALTER all
> tables to UNLOGGED, but failed with "could not change table T to
> unlogged because it references logged table". I'm out of ideas on this
> one.
You'd have to create an load the table in the same transaction, that is,
you'd have to run pg_restore with --single-transaction.
> Any feedback for improving my process? Should I put these ideas somewhere
> as ideas for improvement on pg_restore?
You put your ideas in the right place.
Yours,
Laurenz Albe
