Postgres Pro
Downloads
Home   >   mailing lists

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

From Hiroshi Inoue
Subject Re: [INTERFACES] table very big !!!!!
Date
Msg-id 383A93F4.E8ECCAD1@tpf.co.jp
Whole thread Raw
In response to Re: [INTERFACES] table very big !!!!!  (Pablo Saul Salazar - CESERCOMP <ssalazar@goliat.espol.edu.ec>)
List pgsql-interfaces
Tree view 
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@tpf.co.jp

pgsql-interfaces by date:

Previous
From: Byron Nikolaidis
Date:
Subject: Re: [INTERFACES] weird Access problem
Next
From: Peter Mount
Date:
Subject: Re: [INTERFACES] table very big !!!!!