Postgres Pro
Downloads
Home   >   mailing lists

Re: [INTERFACES] table very big !!!!! - Mailing list pgsql-interfaces

From Peter Mount
Subject Re: [INTERFACES] table very big !!!!!
Date
Msg-id Pine.LNX.4.10.9911221939480.19044-100000@maidast.retep.org.uk
Whole thread Raw
In response to table very big !!!!!  (Pablo Salazar Loaiza <ssalazar@goliat.espol.edu.ec>)
Responses Re: [INTERFACES] table very big !!!!!  (Pablo Saul Salazar - CESERCOMP <ssalazar@goliat.espol.edu.ec>)
List pgsql-interfaces
Tree view 
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/postgresJava PDF Generator: http://www.retep.org.uk/pdf

pgsql-interfaces by date:

Previous
From: Peter Mount
Date:
Subject: Re: [INTERFACES] problem with getBytes
Next
From: Pablo Saul Salazar - CESERCOMP
Date:
Subject: Re: [INTERFACES] table very big !!!!!