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

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 (view raw or flat)
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

pgsql-interfaces by date

Next:From: Paul S. GanneyDate: 1999-11-22 11:39:14
Subject: Getting started with libpq++
Previous:From: Louis BertrandDate: 1999-11-22 01:57:29
Subject: weird Access problem

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