Home > mailing lists

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

From	Wells Oliver
Subject	Faster pg_resore with autovacuum off?
Date	July 27, 2024 00:57:51
Msg-id	CAOC+FBXP+xQ5fXbqpS-JTKq1D90DSxd+Vzz+UYDF0mfq1bVvRQ@mail.gmail.com Whole thread
Responses	Re: Faster pg_resore with autovacuum off? Re: Faster pg_resore with autovacuum off?
List	pgsql-admin

Tree view

Maybe it's an old wives' tale, but I swear I've read a recommendation to turn autovacuum off when doing pg_restore into a new server.. Would it make the restore faster? I think I've restored and then run vacuumdb + analyze, but I wanted to check.

Wells Oliver
wells.oliver@gmail.com

pgsql-admin by date:

From: kaido vaikla
Date: 26 July 2024, 18:12:44
Subject: Re: event_trigger, 'DROP SCHEMA'

From: Ron Johnson
Date: 27 July 2024, 02:18:06
Subject: Re: Faster pg_resore with autovacuum off?

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

Previous

Next