Re: Huge size of Data directory

"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