Re: Huge size of Data directory

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: anthony(at)resolution(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Huge size of Data directory
Date: 2006-01-18 20:54:00
Message-ID: 2751.1137617640@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"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 Michael Fuhr 2006-01-18 21:10:16 Re: Huge size of Data directory
Previous Message Greg Lindstrom 2006-01-18 20:52:45 Swappng Filds