Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id C4E9C47580D
	for <pgsql-sql@postgresql.org>; Sat,  3 Aug 2002 19:02:49 -0400 (EDT)
Received: from joeconway.com (unknown [63.210.180.150])
	by postgresql.org (Postfix) with ESMTP id 26263475165
	for <pgsql-sql@postgresql.org>; Sat,  3 Aug 2002 19:02:49 -0400 (EDT)
Received: from [192.168.5.2] (account jconway HELO joeconway.com)
	by joeconway.com (CommuniGate Pro SMTP 3.5.9)
	with ESMTP-TLS id 1230703; Sat, 03 Aug 2002 15:54:53 -0700
Message-ID: <3D4C60ED.7060402@joeconway.com>
Date: Sat, 03 Aug 2002 16:02:05 -0700
From: Joe Conway <mail@joeconway.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:1.0.0) Gecko/20020530
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Kristian Eide <kreide@online.no>
Cc: Ken Corey <ken@kencorey.com>, pgsql-sql@postgresql.org
Subject: Re: VACUUM not doing its job?
References: <035d01c23b2f$c5d49420$6b97f181@speed>
	<1028412884.28635.22.camel@kenlinux.bithub.org>
	<037901c23b3e$d542a140$6b97f181@speed>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200208/68
X-Sequence-Number: 8914

Kristian Eide wrote:
> This is not good as the database is in use 24/7, and without the indexes
> everything comes to a screeching halt. This means I probably will have to
> stop the programs using the database for the time it takes to re-create the
> indexes; this is better than having to dump/restore everything however :)

Try REINDEX. I don't think that precludes (at least) read access.
   http://www.postgresql.org/idocs/index.php?sql-reindex.html

You should also search the archives for threads on free space maps. You 
most likely need to increase yours. In particular, see:
   http://archives.postgresql.org/pgsql-general/2002-07/msg00972.php

HTH,

Joe