Re: diskspace

From: Rosser Schwarz <rosser(dot)schwarz(at)gmail(dot)com>
To: Geoff Winkless <pgsqladmin(at)geoff(dot)dj>
Cc: PgSQL ADMIN <pgsql-admin(at)postgresql(dot)org>
Subject: Re: diskspace
Date: 2013-02-05 20:40:55
Message-ID: CAFnxYwj2wBOswD+uAnnMZwFND+1vDFnZP2R_n65aZCqAaX3A2g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Feb 5, 2013 at 12:33 PM, Geoff Winkless <pgsqladmin(at)geoff(dot)dj> wrote:

> Indexes are stored separately. There should be no free space (why would
> there be? FILLFACTOR is 100!) and I've vacuumed already.
>

Did you just VACUUM, or did you VACUUM FULL/CLUSTER? Vanilla vacuuming
merely marks space consumed by "dead" tuples as re-usable; it doesn't
reclaim the space and reduce the disk footprint of your tables.

rls

--
:wq

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Geoff Winkless 2013-02-06 08:23:48 Re: diskspace
Previous Message Scott Mead 2013-02-05 20:39:57 Re: diskspace