Re: Disk space taken

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Disk space taken
Date: 2006-07-18 14:52:13
Message-ID: 200607180752.13956@hal.medialogik.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Tuesday 18 July 2006 03:22, "Slavisa Garic" <sgaric(at)gmail(dot)com> wrote:
>
> So as you see no data but over a gig taken in disk space. I've ran this
> after I run vacuumdb --analyze. Also I ran vacuumdb --analyze regularly
> (every 10 minutes) when the database is actively used.
>
> Any help would be really appreciate as this table has been causing me
> some grief for some time.

truncate gridrun;
or
vacuum full analyze ridrun; reindex table gridrun;

Either will reclaim the space.

--
Alan

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2006-07-18 17:19:18 Re: why is scan not using index?
Previous Message kmh496 2006-07-18 14:50:51 why is scan not using index?