From: | Peter Mount <peter(at)retep(dot)org(dot)uk> |
---|---|
To: | Pablo Saul Salazar - CESERCOMP <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 20:37:27 |
Message-ID: | Pine.LNX.4.10.9911222036200.19044-100000@maidast.retep.org.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
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(at)retep(dot)org(dot)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(at)retep(dot)org(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Nathan Kennedy | 1999-11-22 23:04:45 | Linking PgSQL to another SQL Database |
Previous Message | Peter Mount | 1999-11-22 19:40:06 | Re: [INTERFACES] table very big !!!!! |