Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Tom LaneDate: 2006-07-18 17:19:18
Subject: Re: why is scan not using index?
Previous:From: kmh496Date: 2006-07-18 14:50:51
Subject: why is scan not using index?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group