Skip site navigation (1) Skip section navigation (2)

Dump/Restore vs Vacuum Full

From: Adi Alurkar <adi(at)sf(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Dump/Restore vs Vacuum Full
Date: 2004-09-02 00:59:56
Message-ID: 682E2026-FC7B-11D8-9429-000A95C4BD7A@sf.net (view raw or flat)
Thread:
Lists: pgsql-admin
Greetings,

Are there any differences, advantages of running a dump/restore vs 
running the following:1)REINDEX all the tables in all the databases, 
2)VACUUM FULL ANALYZE on all the databases

Assuming the following
1) the system can be offline.
2) PG version 7.4.x
3) pg_autovacuum running as a daemon with 30 minutes sleep but have had 
a few occasions where pg_autovacuum had to be killed and restarted.
4) FSM settings are set > than required by VACUUM ANALYZE VERBOSE 
"test".

-Adi


Responses

pgsql-admin by date

Next:From: tim hallDate: 2004-09-02 06:44:03
Subject: Re: Create Linux Script for PostgreSQL database backup
Previous:From: Richard HarrisDate: 2004-09-01 23:33:43
Subject: Information about psqlODBC parameters

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group