Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 2BFD89FB1F9 for ; Tue, 16 Jan 2007 11:09:13 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 96354-06 for ; Tue, 16 Jan 2007 11:09:00 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id 443009FB1DC for ; Tue, 16 Jan 2007 11:09:00 -0400 (AST) Received: from perhan.alvh.no-ip.org (200-126-100-202.bk7-dsl.surnet.cl [200.126.100.202]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l0GF8vYo029648; Tue, 16 Jan 2007 07:08:58 -0800 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 7B54B32A05; Tue, 16 Jan 2007 12:08:55 -0300 (CLST) Date: Tue, 16 Jan 2007 12:08:55 -0300 From: Alvaro Herrera To: Mario Behring Cc: Tomas Vondra , pgsql-sql@postgresql.org Subject: Re: Droping indexes Message-ID: <20070116150855.GB24671@alvh.no-ip.org> Mail-Followup-To: Mario Behring , Tomas Vondra , pgsql-sql@postgresql.org References: <754782.38721.qm@web30006.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <754782.38721.qm@web30006.mail.mud.yahoo.com> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: ClamAV version 0.88.5, clamav-milter version 0.88.5 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Tue, 16 Jan 2007 07:08:58 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/54 X-Sequence-Number: 27206 Mario Behring wrote: > Hi Tomas, > > Thank you. > > Please help me here.....I am not a database guy...........how do I use this CLUSTER command and what does it do? Please keep in mind that I do not have disk space left......... If the disk is full you cannot use CLUSTER anyway. Suggestion: make a note of the indexes that exist. Drop them. Do a VACUUM FULL of the table. Create the indexes again. After that's done: 1. read the CLUSTER documentation, as it may help you in the future 2. consider restructuring the table so that redundant information is kept only on one place (for example, the eventackuser could probably be put on a separate table and on this one store just an integer ID). This will make the table and the index on that column a lot smaller. 3. add more disks to your installation 4. research a more effective VACUUM policy -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support