| From: | "Charles(dot)Hou" <ivan(dot)hou(at)msa(dot)hinet(dot)net> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Auto Vacuum question? |
| Date: | 2007-06-04 14:12:48 |
| Message-ID: | 1180966368.172224.250500@x35g2000prf.googlegroups.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas | 2007-06-04 14:39:18 | Re: Need a wee bit more info on PostgreSQL's SSL security options |
| Previous Message | Simon Riggs | 2007-06-04 07:49:47 | Re: Attempt to re-archive existing WAL logsafterrestoringfrom backup |