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

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

pgsql-interfaces by date

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

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