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 03:57:51
Msg-id	CAOC+FBXP+xQ5fXbqpS-JTKq1D90DSxd+Vzz+UYDF0mfq1bVvRQ@mail.gmail.com Whole thread Raw
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, 21:12:44
Subject: Re: event_trigger, 'DROP SCHEMA'

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

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

Previous

Next