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

From: Peter Mount <peter(at)retep(dot)org(dot)uk>
To: Pablo Salazar Loaiza <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 19:40:06
Message-ID: Pine.LNX.4.10.9911221939480.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 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 Peter Mount 1999-11-22 20:37:27 Re: [INTERFACES] table very big !!!!!
Previous Message Peter Mount 1999-11-22 19:28:37 Re: [INTERFACES] problem with getBytes