X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4E1415E4E3E for ; Sat, 4 Sep 2004 14:07:37 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 18179-10 for ; Sat, 4 Sep 2004 13:06:23 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 2CD5B5E4A53 for ; Sat, 4 Sep 2004 14:05:12 +0100 (BST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i84D3fLq025475 for ; Sat, 4 Sep 2004 13:03:41 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i84CZmsW022127 for pgsql-admin@postgresql.org; Sat, 4 Sep 2004 12:35:48 GMT From: Gaetano Mendola X-Newsgroups: comp.databases.postgresql.admin Subject: Re: Dump/Restore vs Vacuum Full Date: Sat, 04 Sep 2004 12:19:38 +0200 Organization: PYRENET Midi-pyrenees Provider Lines: 34 Message-ID: <413996BA.9070806@bigfoot.com> References: <682E2026-FC7B-11D8-9429-000A95C4BD7A@sf.net> <234DDAC5-FDCB-11D8-A503-000A95C4BD7A@sf.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@pyrenet.fr To: Adi Alurkar User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803) X-Accept-Language: en-us, en In-Reply-To: <234DDAC5-FDCB-11D8-A503-000A95C4BD7A@sf.net> X-Enigmail-Version: 0.85.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.1 tagged_above=0.0 required=5.0 tests=NO_DNS_FOR_FROM X-Spam-Level: * X-Archive-Number: 200409/38 X-Sequence-Number: 14741 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