Re: Vacuum Doesn't Recover Disk Space

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Vacuum Doesn't Recover Disk Space
Дата
Msg-id dcc563d10711060942t13850012p986b1d6db04e96e0@mail.gmail.com
обсуждение исходный текст
Ответ на Vacuum Doesn't Recover Disk Space  ("j a" <inboundfilter@gmail.com>)
Ответы Re: Vacuum Doesn't Recover Disk Space
Список pgsql-admin
On 11/6/07, j a <inboundfilter@gmail.com> wrote:
> I have a large table that I remove around 10m rows from every 2 months. I
> try running Vacuum Full w/Analyze (both boxes checked in PG Admin), but the
> disk space is never returned to the system. Any way I can force this?
>
> I'm running 7.4 on CentOS4.3

You likely have index bloat.  try reindexing.

В списке pgsql-admin по дате отправления:

Предыдущее
От: "j a"
Дата:
Сообщение: Vacuum Doesn't Recover Disk Space
Следующее
От: Devrim GÜNDÜZ
Дата:
Сообщение: Re: Source of pgpool2 manual