Обсуждение: Dump/Restore vs Vacuum Full
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
Any comments ? knock knock!! is this thing ON? On Sep 1, 2004, at 5:59 PM, Adi Alurkar wrote: > 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 > > > ---------------------------(end of > broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if > your > joining column's datatypes do not match > > -- Adi Alurkar (DBA sf.NET) <adi@vasoftware.com> 1024D/79730470 A491 5724 74DE 956D 06CB D844 6DF1 B972 7973 0470
Adi Alurkar wrote: > Any comments ? > knock knock!! is this thing ON? > > On Sep 1, 2004, at 5:59 PM, Adi Alurkar wrote: > >> 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". Go for a vacuum full and reindex of all tables. The advantages are that the dump/restore is longer if your vacuum the database quite enough BTW, with 7.4.x there is no needs to run vacuum full so much Regards Gaetano Mendola