Re: Huge size of Data directory

From: "Anthony Presley" <anthony(at)resolution(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: anthony(at)resolution(dot)com, pgsql-novice(at)postgresql(dot)org
Subject: Re: Huge size of Data directory
Date: 2006-01-18 23:07:39
Message-ID: 3641.192.168.5.4.1137625659.squirrel@216.63.139.110
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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(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 ...
> http://www.postgresql.org/docs/8.1/static/maintenance.html
>
> regards, tom lane
>

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Lynna Landstreet 2006-01-19 11:11:36 Problems with select statement
Previous Message Anthony Presley 2006-01-18 22:02:27 Huge size of Data directory