From: | Andrew Sullivan <ajs(at)crankycanuck(dot)ca> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Auto Vacuum question? |
Date: | 2007-06-07 15:30:42 |
Message-ID: | 20070607153042.GD14087@phlogiston.dyndns.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, Jun 04, 2007 at 04:15:12AM -0700, ivan(dot)hou(at)msa(dot)hinet(dot)net wrote:
> after i executed the command " vaccumdb -f -z testdb", but the size
> just decreased 1 or 2MB...
> what's the problem?
vacuumdb -f does a FULL vacuum, which is blocking and compacts the
tables. If it only compacted 1 or 2 M, then there are two
possibilities:
1. You really do have that much data. You haven't told us
anything about the data, what it looks like, how wide the tables are,
whether you have large objects &c., whether the character set is
multibyte. . .
2. You have at least one long-running transaction that is
perhaps doing nothing, but that is preventing VACUUM from recovering
space. What does ps -auxww | grep postgres (or something equivalant)
show you?
A
--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
Users never remark, "Wow, this software may be buggy and hard
to use, but at least there is a lot of code underneath."
--Damien Katz
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2007-06-07 15:42:49 | Re: Limitations on 7.0.3? |
Previous Message | Martijn van Oosterhout | 2007-06-07 15:28:04 | Re: Jumping Weekends |