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.
vacuum full analyze ridrun; reindex table gridrun;
Either will reclaim the space.
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2006-07-18 17:19:18|
|Subject: Re: why is scan not using index? |
|Previous:||From: kmh496||Date: 2006-07-18 14:50:51|
|Subject: why is scan not using index?|