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. (view raw, whole thread or download thread mbox)
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

Running 7.1, I believe.


> "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 ...
>    regards, tom lane

In response to


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-2017 The PostgreSQL Global Development Group