Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] table very big !!!!!

From: Hannu Krosing <hannu(at)tm(dot)ee>
To: Pablo Salazar Loaiza <ssalazar(at)goliat(dot)espol(dot)edu(dot)ec>
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] table very big !!!!!
Date: 1999-11-22 18:00:59
Message-ID: 383984DB.D8FE4C2D@tm.ee (view raw or flat)
Thread:
Lists: pgsql-interfaces
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

In response to

pgsql-interfaces by date

Next:From: Rafal Piotrowski (CSCS)Date: 1999-11-22 18:10:05
Subject: problem with getBytes
Previous:From: Pablo Salazar LoaizaDate: 1999-11-22 17:33:47
Subject: table very big !!!!!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group