Re: Huge size of Data directory - Mailing list pgsql-novice

From Tom Lane
Subject Re: Huge size of Data directory
Date
Msg-id 2751.1137617640@sss.pgh.pa.us
Whole thread Raw
In response to Huge size of Data directory  ("Anthony Presley" <anthony@resolution.com>)
Responses Re: Huge size of Data directory  ("Anthony Presley" <anthony@resolution.com>)
List pgsql-novice
"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

pgsql-novice by date:

Previous
From: Greg Lindstrom
Date:
Subject: Swappng Filds
Next
From: Michael Fuhr
Date:
Subject: Re: Huge size of Data directory