> On Jul 27, 2024, at 1:48 PM, Ron Johnson <ronljohnsonjr@xxxxxxxxx> 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???