Re: Cleaning up large objects

Поиск
Список
Период
Сортировка
От Kris Jurka
Тема Re: Cleaning up large objects
Дата
Msg-id Pine.BSO.4.56.0408101236340.26464@leary.csoft.net
обсуждение исходный текст
Ответ на Re: Cleaning up large objects  ("Ole Streicher" <ole-usenet-spam@gmx.net>)
Список pgsql-jdbc

On Tue, 10 Aug 2004, Ole Streicher wrote:

> When I execute "vacuum -a -v -z", I get
> However, no space is freed. Why?
>

Without -f (FULL) vacuum will not actually free space, but just mark it
for later reuse.  If you are seeing a growing rate over time that you
think should hit a steady state, perhaps your free space map settings
aren't large enough.

Kris Jurka

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Cleaning up large objects
Следующее
От: "Luke (Terry) Vanderfluit"
Дата:
Сообщение: jdk1.5Beta2 and postgres 7.4.3