Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 26A8A47646B for ; Sat, 2 Nov 2002 20:20:31 -0500 (EST) Received: from candle.pha.pa.us (momjian.navpoint.com [207.106.42.251]) by postgresql.org (Postfix) with ESMTP id 2A06F47646A for ; Sat, 2 Nov 2002 20:20:29 -0500 (EST) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.10.1) id gA31K4N00212; Sat, 2 Nov 2002 20:20:04 -0500 (EST) From: Bruce Momjian Message-Id: <200211030120.gA31K4N00212@candle.pha.pa.us> Subject: Re: Different size in the DATA directory In-Reply-To: <20021102143335.GC13252@dyatel.antar.bryansk.ru> To: "Alexander M. Pravking" Date: Sat, 2 Nov 2002 20:20:04 -0500 (EST) Cc: Tim Perdue , "Maur?cio Sessue Otta" , pgsql-sql@postgresql.org X-Mailer: ELM [version 2.4ME+ PL99 (25)] MIME-Version: 1.0 Content-Type: multipart/mixed; boundary=ELM1036286404-15342-0_ Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/36 X-Sequence-Number: 10178 --ELM1036286404-15342-0_ Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII Alexander M. Pravking wrote: > 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? No perl? I am no perl guy, but I assumed everyone had that already. I just looked at the code, and yes, it should use sed rather than perl, especially since it is using it just for processing command line args. Seems it is a problem/bug for you. Patch applied to use sed rather than perl. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 --ELM1036286404-15342-0_ Content-Transfer-Encoding: 7bit Content-Type: text/plain Content-Disposition: inline; filename="/bjm/diff" Index: contrib/reindexdb/reindexdb =================================================================== RCS file: /cvsroot/pgsql-server/contrib/reindexdb/reindexdb,v retrieving revision 1.2 diff -c -c -r1.2 reindexdb *** contrib/reindexdb/reindexdb 18 Oct 2002 18:41:20 -0000 1.2 --- contrib/reindexdb/reindexdb 3 Nov 2002 01:19:21 -0000 *************** *** 111,118 **** dbname="$2" shift ;; ! -d*|--dbname=*) ! dbname=`echo $1 | perl -pn -e 's/^--?d(bname=)?//'` ;; # Reindex specific Table. Disables index reindexing. --- 111,121 ---- dbname="$2" shift ;; ! -d*) ! dbname=`echo "$1" | sed 's/^-d/'` ! ;; ! --dbname=*) ! dbname=`echo "$1" | sed 's/^--dbname=//'` ;; # Reindex specific Table. Disables index reindexing. *************** *** 120,127 **** table="$2" shift ;; ! -t*|--table=*) ! table=`echo $1 | perl -pn -e 's/^--?t(able=)?//'` ;; # Reindex specific index. Disables table reindexing. --- 123,133 ---- table="$2" shift ;; ! -t*) ! table=`echo "$1" | sed 's/^-t//'` ! ;; ! --table=*) ! table=`echo "$1" | sed 's/^--table=//'` ;; # Reindex specific index. Disables table reindexing. *************** *** 129,136 **** index="$2" shift ;; ! -i*|--index=*) ! index=`echo $1 | perl -pn -e 's/^--?i(ndex=)?//'` ;; # Yeah, no options? Whine, and show usage. --- 135,145 ---- index="$2" shift ;; ! -i*) ! index=`echo "$1" | sed 's/^-i//'` ! ;; ! --index=*) ! index=`echo "$1" | sed 's/^--index=//'` ;; # Yeah, no options? Whine, and show usage. --ELM1036286404-15342-0_--