Auto Vacuum question? - Mailing list pgsql-general

From ivan.hou@msa.hinet.net
Subject Auto Vacuum question?
Date
Msg-id 1180955712.688195.233560@i38g2000prf.googlegroups.com
Whole thread Raw
Responses Re: Auto Vacuum question?
List pgsql-general
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


pgsql-general by date:

Previous
From: Johannes Konert
Date:
Subject: Re: Suppress checking of chmod 700 on data-dir?
Next
From: "Erik Jones"
Date:
Subject: Re: Large Database \d: ERROR: cache lookup failed for relation ...