Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group