Re: Huge size of Data directory

I do routinely vacuum.  I vacuum'd it yesterday, and about a week before
that, and probably on a 2-3 week basis prior to that.  And, I vacuum using
"analyze".

Running 7.1, I believe.

--Anthony

> "Anthony Presley" <anthony@resolution.com> writes:
>> However, more surprising to me is that it has (over the past few years)
>> become HUGE.  It's currently 606MB.  Almost all of this space is sitting
>> in data/base/16556 and data/pg_xlog.
>
>> The problem I have with this space ... is that I only have about 8MB of
>> data stored in the database (according to pg_dump and pg_dumpall).
>
> You need to read the documentation about routine vacuuming ...
> http://www.postgresql.org/docs/8.1/static/maintenance.html
>
>    regards, tom lane
>