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 179F63A3C48 for ; Mon, 25 Oct 2004 12:02:56 +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 40792-01 for ; Mon, 25 Oct 2004 11:02:49 +0000 (GMT) Received: from linux.finestmedia.tv (linux.finestmedia.tv [213.180.31.12]) by svr1.postgresql.org (Postfix) with ESMTP id A071F3A2B23 for ; Mon, 25 Oct 2004 12:02:47 +0100 (BST) Received: from rix (unknown [192.168.2.27]) by linux.finestmedia.tv (Postfix) with SMTP id 5A80818E718 for ; Mon, 25 Oct 2004 13:58:48 +0300 (EEST) From: "Rigmor Ukuhe" To: Subject: Index relation size Date: Mon, 25 Oct 2004 14:02:46 +0300 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Importance: Normal 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/333 X-Sequence-Number: 15326 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? Rigmor Ukuhe --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.779 / Virus Database: 526 - Release Date: 19.10.2004