Received: from hu.tm.ee (isdn-54.uninet.ee [194.204.0.118])
	by hub.org (8.9.3/8.9.3) with ESMTP id NAA29277
	for <pgsql-interfaces@postgreSQL.org>;
	Mon, 22 Nov 1999 13:00:30 -0500 (EST) (envelope-from hannu@tm.ee)
Received: from tm.ee (localhost [127.0.0.1]) by hu.tm.ee (Postfix) with ESMTP
	id 8AA617210; Mon, 22 Nov 1999 20:01:00 +0200 (EET)
Sender: hannu@hu.tm.ee
Message-ID: <383984DB.D8FE4C2D@tm.ee>
Date: Mon, 22 Nov 1999 20:00:59 +0200
From: Hannu Krosing <hannu@tm.ee>
Organization: Trust-O-Matic =?iso-8859-1?Q?O=DC?=
X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.13-7mdk i686)
X-Accept-Language: en
MIME-Version: 1.0
To: Pablo Salazar Loaiza <ssalazar@goliat.espol.edu.ec>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] table  very big !!!!!
References: <38397E7A.9CC12448@goliat.espol.edu.ec>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Pablo Salazar Loaiza wrote:
> 
> Hello all
> 
> I have a DB in Postgres, and i have one application that work with this
> DB, and exist one table where dialy is writing register in this table,
> but to midnigth , i do delete from table.
> 
> But the size always is growing.
>

You should run the database command 

>analyze;

that will get rid of old tuples that are no longer used

--------------
Hannu