From: Hiroshi Inoue <Inoue@tpf.co.jp>
To: Pablo Saul Salazar - CESERCOMP <ssalazar@goliat.espol.edu.ec>
Cc: Peter Mount <peter@retep.org.uk>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] table very big !!!!!
Date: Tue, 23 Nov 1999 22:17:40 +0900
Message-ID: <383A93F4.E8ECCAD1@tpf.co.jp> (raw)
References: <Pine.GSO.3.96.991122151721.29977A-100000@goliat.espol.edu.ec>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: Inoue@tpf.co.jp, ssalazar@goliat.espol.edu.ec, peter@retep.org.uk
Subject: Re: [INTERFACES] table very big !!!!!
In-Reply-To: <383A93F4.E8ECCAD1@tpf.co.jp>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox