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
>
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 |