| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Dimitrios Apostolou <jimis(at)gmx(dot)net>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Experience and feedback on pg_restore --data-only |
| Date: | 2025-03-23 16:00:39 |
| Message-ID: | 455d28421ae33c73b73a6f527d2f72816ca5dd29.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Igor Korot | 2025-03-23 17:38:18 | Re: Determine server version from psql script |
| Previous Message | Adrian Klaver | 2025-03-23 15:37:11 | Re: Experience and feedback on pg_restore --data-only |