Re: Faster pg_resore with autovacuum off? - Mailing list pgsql-admin

From Scott Ribe
Subject Re: Faster pg_resore with autovacuum off?
Date
Msg-id 154A742E-51A3-4A56-A570-65B9E6A14A4D@elevated-dev.com
Whole thread Raw
In response to Re: Faster pg_resore with autovacuum off?  (Ron Johnson <ronljohnsonjr@gmail.com>)
Responses Re: Faster pg_resore with autovacuum off?
Re: Faster pg_resore with autovacuum off?
List pgsql-admin
> On Jul 27, 2024, at 1:48 PM, Ron Johnson <ronljohnsonjr@gmail.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
onhardware). 

The other argument I've seen, that if there's a crash during restore you'll have a corrupted database, is bogus. What
areyou going to try to do with a database if there's a crash during restore??? 


pgsql-admin by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Faster pg_resore with autovacuum off?
Next
From: Ron Johnson
Date:
Subject: Re: Faster pg_resore with autovacuum off?