From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-admin@postgresql.org
Subject: Re: the right time to vacuum database?
Date: Fri, 8 Jun 2007 10:20:30 -0400
Message-ID: <20070608142030.GX17144@phlogiston.dyndns.org> (raw)
In-Reply-To: <1181309395.707448.201490@i13g2000prf.googlegroups.com>
References: <1181039589.643323.59660@r19g2000prf.googlegroups.com>
<20070605132546.GI4818@phlogiston.dyndns.org>
<1181089690.963738.260660@n15g2000prd.googlegroups.com>
<20070606195101.GF11545@phlogiston.dyndns.org>
<1181200023.281625.249120@n15g2000prd.googlegroups.com>
<20070607174639.GG14087@phlogiston.dyndns.org>
<1181309395.707448.201490@i13g2000prf.googlegroups.com>
On Fri, Jun 08, 2007 at 06:29:55AM -0700, Charles.Hou wrote:
>
> i have traced the size of the table. About 1000 new rows will be
> inserted into the table in one day. each row has 300 bytes.
> 1000*300/1024=293K, but the size of this table had been increased 3MB.
> 3MB-293K=2.7MB...Why?where is the 2.7MB?
How do you know what the size of the table is? You had at least two
tables you were working on before. I think there must be something
you're not communicating completely. (And why are you worried about
less than 3 Meg anyway? Regular vacuum will leave some empty space
around for new data, which means you don't have to go down to the
filesystem to make the file bigger before you write it it. This is a
Good Thing.)
Please go back and run VACUUM VERBOSE on the table you killed the
vacuum on before.
A
--
Andrew Sullivan | ajs@crankycanuck.ca
However important originality may be in some fields, restraint and
adherence to procedure emerge as the more significant virtues in a
great many others. --Alain de Botton
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-sql@postgresql.org
Cc: ajs@crankycanuck.ca, pgsql-admin@postgresql.org
Subject: Re: the right time to vacuum database?
In-Reply-To: <20070608142030.GX17144@phlogiston.dyndns.org>
* 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