From: Hannu Krosing <hannu@tm.ee>
To: Pablo Salazar Loaiza <ssalazar@goliat.espol.edu.ec>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] table very big !!!!!
Date: Mon, 22 Nov 1999 20:00:59 +0200
Message-ID: <383984DB.D8FE4C2D@tm.ee> (raw)
References: <38397E7A.9CC12448@goliat.espol.edu.ec>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: hannu@tm.ee, ssalazar@goliat.espol.edu.ec
Subject: Re: [INTERFACES] table very big !!!!!
In-Reply-To: <383984DB.D8FE4C2D@tm.ee>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox