From: ivan.hou@msa.hinet.net
To: pgsql-general@postgresql.org
Subject: Auto Vacuum question?
Date: Mon, 04 Jun 2007 04:15:12 -0700
Message-ID: <1180955712.688195.233560@i38g2000prf.googlegroups.com> (raw)
i set the auto vacuum option to enable. but my database size(hard-disk
space) still increased from 420MB to 440MB in 8 hours. most of the
operations in this database are the "Select" query command, just few
of "Update or Insert".
why it can be increased so strongly?
after i executed the command " vaccumdb -f -z testdb", but the size
just decreased 1 or 2MB...
what's the problem?
how to know which command(select,insert....) takes the hurge loading
to database in this time?
computer environment:
System: Red Hat Enterprise 4
Postgresql Server: 8.0.13
count of client connected : about 100 pc
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: ivan.hou@msa.hinet.net
Subject: Re: Auto Vacuum question?
In-Reply-To: <1180955712.688195.233560@i38g2000prf.googlegroups.com>
References: <1180955712.688195.233560@i38g2000prf.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