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

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
>
>

In response to

Responses

Browse pgsql-interfaces by date

  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