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

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Pablo Saul Salazar - CESERCOMP <ssalazar(at)goliat(dot)espol(dot)edu(dot)ec>
Cc: Peter Mount <peter(at)retep(dot)org(dot)uk>, pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] table very big !!!!!
Date: 1999-11-23 13:17:40
Message-ID: 383A93F4.E8ECCAD1@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Pablo Saul Salazar - CESERCOMP wrote:
>
> 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!!! ???
>

Are there any pending transactions ?
If a very old transaction is alive,vacuum never
remove deleted tuples.

Regards.

Hiroshi Inoue
Inoue(at)tpf(dot)co(dot)jp

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Peter Mount 1999-11-23 20:43:08 Re: [INTERFACES] problem with getBytes
Previous Message Rudolf ter Haar 1999-11-23 12:32:28 Re: A Question about Large Object