Re: Disk space taken - Mailing list pgsql-novice

From Alan Hodgson
Subject Re: Disk space taken
Date
Msg-id 200607180752.13956@hal.medialogik.com
Whole thread Raw
In response to Disk space taken  ("Slavisa Garic" <sgaric@gmail.com>)
List pgsql-novice
On Tuesday 18 July 2006 03:22, "Slavisa Garic" <sgaric@gmail.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

pgsql-novice by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: Disk space taken
Next
From: kmh496
Date:
Subject: why is scan not using index?