| From: | Doug McNaught <doug(at)mcnaught(dot)org> |
|---|---|
| To: | "Esger Abbink" <pggeneral(at)bumblebeast(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: data directory growing huge |
| Date: | 2003-09-24 14:17:24 |
| Message-ID: | m3smmm9sp7.fsf@varsoon.wireboard.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Esger Abbink" <pggeneral(at)bumblebeast(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shridhar Daithankar | 2003-09-24 14:17:49 | Re: data directory growing huge |
| Previous Message | scott.marlowe | 2003-09-24 14:11:51 | Re: [GENERAL] Fatal error: Allowed memory size of 8388608 |