X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 79F19D9187 for ; Fri, 16 Sep 2005 13:30:15 -0300 (ADT) 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 09779-05 for ; Fri, 16 Sep 2005 16:30:06 +0000 (GMT) Received: from smtp-out4.blueyonder.co.uk (smtp-out4.blueyonder.co.uk [195.188.213.7]) by svr1.postgresql.org (Postfix) with ESMTP id 15DC1D91BB for ; Fri, 16 Sep 2005 13:30:04 -0300 (ADT) Received: from [82.34.97.4] ([82.34.97.4]) by smtp-out4.blueyonder.co.uk with Microsoft SMTPSVC(5.0.2195.6713); Fri, 16 Sep 2005 17:30:53 +0100 Message-ID: <432AF30B.9020509@blueyonder.co.uk> Date: Fri, 16 Sep 2005 17:30:03 +0100 From: Peter Childs User-Agent: Debian Thunderbird 1.0.2 (X11/20050602) X-Accept-Language: en-us, en MIME-Version: 1.0 Cc: pgsql-admin@postgresql.org Subject: Re: 7.4 <-> 8.0 References: <1126811405.12350.29.camel@localhost> <1126886236.12350.106.camel@localhost> In-Reply-To: <1126886236.12350.106.camel@localhost> X-Enigmail-Version: 0.91.0.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 16 Sep 2005 16:30:53.0756 (UTC) FILETIME=[01E937C0:01C5BADC] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 required=5 tests=[none] X-Spam-Level: X-Archive-Number: 200509/259 X-Sequence-Number: 18996 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Warren Snelling wrote: > > > Would you suggest scripting the vacuum full / reindex process to > run periodically (once a week or so)? Right now disk space on this > machine is not an issue, but vacuuming and reindexing occasionally > should keep the db from consuming too much excess space. > 7.4 has a problem with vacuuming indexes I seam to remember. I think thats this is one of the fixes in 8.0. Apart from anything a large index is going to slow your database down as the database has to scan past junk everytime it does an index lookup. Peter Childs -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDKvMKJWgkOaNnHdMRAsBEAKCv3ZWdy1a4+qQG0U9Ov85TPCembQCfazPH QVPj5xEDPSumy1Z4FUSTgf4= =As1l -----END PGP SIGNATURE-----