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
Running 7.1, I believe.
> "Anthony Presley" <anthony(at)resolution(dot)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 ...
> regards, tom lane
In response to
pgsql-novice by date
|Next:||From: Lynna Landstreet||Date: 2006-01-19 11:11:36|
|Subject: Problems with select statement|
|Previous:||From: Anthony Presley||Date: 2006-01-18 22:02:27|
|Subject: Huge size of Data directory|