Re: data directory growing huge - Mailing list pgsql-general

From Doug McNaught
Subject Re: data directory growing huge
Date
Msg-id m3smmm9sp7.fsf@varsoon.wireboard.com
Whole thread Raw
In response to data directory growing huge  ("Esger Abbink" <pggeneral@bumblebeast.com>)
List pgsql-general
"Esger Abbink" <pggeneral@bumblebeast.com> writes:

> On two production server (7.2rc2) of ours the data directory is growing
> to very large sizes while the data that is actually in the db's isnt 1.
> that large and 2. growing.

You're running a release candidate of 7.2?  That's pretty old and has
known bugs...

Your problem, however, is probably index bloat, which is not fixed by
VACUUM in the version you're running.  If you REINDEX you should see
storage usage go back to normal.

The upcoming 7.4 should suffer much less from the index bloat problem.

-Doug

pgsql-general by date:

Previous
From: Shridhar Daithankar
Date:
Subject: Re: data directory growing huge
Next
From: "scott.marlowe"
Date:
Subject: Re: [ADMIN] Fatal error: Allowed memory size of 8388608