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

On Mon, 22 Nov 1999, 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

Ah, try running first vacuum; then vacuum analyze. The first one will
truncate the table removing the wasted space. The second simply rebuilds
some statistics about the table.

Peter

> 
> another solutions!!! ???
> 
> Thanks
> 
> 
> Pablo Salazar Loaiza
>  Asistente de Redes
>   CESERCOMP-ESPOL
> 
> 
> On Mon, 22 Nov 1999, Peter Mount wrote:
> 
> > On Mon, 22 Nov 1999, 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.
> > 
> > Are you running a vacuum after the delete?
> > 
> > Peter
> > 
> > --
> >        Peter T Mount peter@retep.org.uk
> >       Main Homepage: http://www.retep.org.uk
> > PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
> >  Java PDF Generator: http://www.retep.org.uk/pdf
> > 
> > 
> 

--      Peter T Mount peter@retep.org.uk     Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgresJava PDF Generator: http://www.retep.org.uk/pdf