On Sat, Jul 27, 2024 at 4:06 PM Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx> wrote:
> 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???
Josh Berkus' blog post, which I linked to earlier, recommended that, and a lot more, 10 years ago. It all still holds up. Bigger servers just means some values need enlarging.
