> On Jul 27, 2024, at 1:48 PM, Ron Johnson <ronljohnsonjr(at)gmail(dot)com> wrote:
>
> You can't forget to enable autovacuum when it's in the same script as the pg_restore.
Similar argument applies to turning off fsync, which I have found to sometimes make a significant difference (depending on hardware).
The other argument I've seen, that if there's a crash during restore you'll have a corrupted database, is bogus. What are you going to try to do with a database if there's a crash during restore???