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
>