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 0E8423A412E for ; Mon, 25 Oct 2004 18:51:50 +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 85943-10 for ; Mon, 25 Oct 2004 17:51:39 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 30ED13A4111 for ; Mon, 25 Oct 2004 18:51:39 +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 i9PHpbJ7088970 for ; Mon, 25 Oct 2004 17:51:37 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i9PHp0PM088793 for pgsql-admin@postgresql.org; Mon, 25 Oct 2004 17:51:00 GMT From: Gaetano Mendola X-Newsgroups: comp.databases.postgresql.admin Subject: Re: Index relation size Date: Mon, 25 Oct 2004 19:50:59 +0200 Organization: PYRENET Midi-pyrenees Provider Lines: 19 Message-ID: <417D3D03.5020102@bigfoot.com> References: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@pyrenet.fr To: Rigmor Ukuhe User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913) X-Accept-Language: en-us, en In-Reply-To: X-Enigmail-Version: 0.86.1.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=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/338 X-Sequence-Number: 15331 Rigmor Ukuhe wrote: > Hi, > > I have table with size ~35 MB, it has several indexes and couple of them are > well over 500 MB in size (they are indexes with 3-4 columns involved, with > datatypes like varchar, int4 , timestamp, boolean). > Database is VACUUMed nightly, version is 7.2.4 (cant upgrade to newest > version at the moment). Are these > index sizes indicating some problems with our Postgres server? If you do not vacuum full, this is normal. Using a version > 7.4 then a normal vacuum "shall" be enough. Regards Gaetano Mendola