From: | Pablo Saul Salazar - CESERCOMP <ssalazar(at)goliat(dot)espol(dot)edu(dot)ec> |
---|---|
To: | Peter Mount <peter(at)retep(dot)org(dot)uk> |
Cc: | pgsql-interfaces(at)postgreSQL(dot)org |
Subject: | Re: [INTERFACES] table very big !!!!! |
Date: | 1999-11-22 10:20:20 |
Message-ID: | Pine.GSO.3.96.991122151721.29977A-100000@goliat.espol.edu.ec |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
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
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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Paul S. Ganney | 1999-11-22 11:39:14 | Getting started with libpq++ |
Previous Message | Louis Bertrand | 1999-11-22 01:57:29 | weird Access problem |