Re: Disk space taken

Поиск
Список
Период
Сортировка
От Alan Hodgson
Тема Re: Disk space taken
Дата
Msg-id 200607180752.13956@hal.medialogik.com
обсуждение исходный текст
Ответ на Disk space taken  ("Slavisa Garic" <sgaric@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Richard Broersma Jr
Дата:
Сообщение: Re: Disk space taken
Следующее
От: kmh496
Дата:
Сообщение: why is scan not using index?