Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id EF65C47657E for ; Sat, 2 Nov 2002 09:33:49 -0500 (EST) Received: from dyatel.antar.bryansk.ru (dyatel.antar.bryansk.ru [195.239.214.85]) by postgresql.org (Postfix) with ESMTP id 149AB476380 for ; Sat, 2 Nov 2002 09:33:43 -0500 (EST) Received: from drweb by dyatel.antar.bryansk.ru with drweb-scanned (Exim 4.10) id 187zLH-000Bsu-00; Sat, 02 Nov 2002 17:33:39 +0300 Received: from fduch by dyatel.antar.bryansk.ru with local (Exim 4.10) id 187zLD-000Bsf-00; Sat, 02 Nov 2002 17:33:35 +0300 Date: Sat, 2 Nov 2002 17:33:35 +0300 From: "Alexander M. Pravking" To: Bruce Momjian Cc: Tim Perdue , Maur?cio Sessue Otta , pgsql-sql@postgresql.org Subject: Re: Different size in the DATA directory Message-ID: <20021102143335.GC13252@dyatel.antar.bryansk.ru> References: <3DC2A578.6040605@perdue.net> <200211020348.gA23m0w10244@candle.pha.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=koi8-r Content-Disposition: inline In-Reply-To: <200211020348.gA23m0w10244@candle.pha.pa.us> User-Agent: Mutt/1.4i X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/33 X-Sequence-Number: 10175 On Fri, Nov 01, 2002 at 10:48:00PM -0500, Bruce Momjian wrote: > Tim, I guess your problem is dead index pages that can't be reclaimed, > and it isn't fixed in 7.3. Only REINDEX fixes it, and we have a > /contrib/reindexdb script in 7.3. As I see, contrib/reindexdb requires perl for commandline procesing. I don't think it's a good idea, since e.g. FreeBSD 5.0-CURRENT have no perl in standard distribution. Thomas, why not to use sed? -- Fduch M. Pravking