Received: from sd.tpf.co.jp (sd.tpf.co.jp [210.161.239.34])
	by hub.org (8.9.3/8.9.3) with ESMTP id XAA29413
	for <pgsql-interfaces@postgreSQL.org>;
	Mon, 22 Nov 1999 23:18:34 -0500 (EST) (envelope-from Inoue@tpf.co.jp)
Received: from tpf.co.jp ([126.0.1.56] (may be forged))
	by sd.tpf.co.jp (2.5 Build 2640 (Berkeley 8.8.6)/8.8.4) with ESMTP
	id NAA02787; Tue, 23 Nov 1999 13:17:43 +0900
Sender: inoue@sd.tpf.co.jp
Message-ID: <383A93F4.E8ECCAD1@tpf.co.jp>
Date: Tue, 23 Nov 1999 22:17:40 +0900
From: Hiroshi Inoue <Inoue@tpf.co.jp>
X-Mailer: Mozilla 4.08 [muriyari-ja_euc] (X11; I; Linux 2.2.9 i686)
MIME-Version: 1.0
To: Pablo Saul Salazar - CESERCOMP <ssalazar@goliat.espol.edu.ec>
CC: Peter Mount <peter@retep.org.uk>, pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] table  very big !!!!!
References: <Pine.GSO.3.96.991122151721.29977A-100000@goliat.espol.edu.ec>
Content-Type: text/plain; charset=iso-2022-jp
Content-Transfer-Encoding: 7bit

Pablo Saul Salazar - CESERCOMP wrote:
> 
> Yes, i have a C program that first do delete and after run command vacuum
> analyze, but this command dont do nothing, because the size the table
> grow
> 
> another solutions!!! ???
>

Are there any pending transactions ?
If a very old transaction is alive,vacuum never
remove deleted tuples. 

Regards.

Hiroshi Inoue
Inoue@tpf.co.jp