From: Charles.Hou <ivan.hou@msa.hinet.net>
To: pgsql-admin@postgresql.org
Subject: Re: the right time to vacuum database?
Date: Fri, 08 Jun 2007 08:20:36 -0700
Message-ID: <1181316036.270635.44890@o11g2000prd.googlegroups.com> (raw)
In-Reply-To: <20070608142030.GX17144@phlogiston.dyndns.org>
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>
<20070608142030.GX17144@phlogiston.dyndns.org>
On Jun 8, 10:20 pm, a...@crankycanuck.ca (Andrew Sullivan) wrote:
> 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 | a...@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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
because if the size of database have been increased 36MB in one day ,
then it will be 1G MB increased after 1 month. so i worry about the
size. other strange thing, if i block all postgresql client and run
vacuumdb, there will have about 100MB free space.
> How do you know what the size of the table is?
i got the relname from the pg_class and go to find the relname on the
disk.
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: ivan.hou@msa.hinet.net, pgsql-admin@postgresql.org
Subject: Re: the right time to vacuum database?
In-Reply-To: <1181316036.270635.44890@o11g2000prd.googlegroups.com>
* 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