Обсуждение: table size is not changed

Поиск

Список

Период

Сортировка

table size is not changed

От

AI Rumman

Дата:

03 февраля 2010 г., 05:44:09

I deleted 70000 rows from a table and then execute

vacuum analyze <table>.

But table size not yet changed.

I am using Postgresql 8.1.

Could anyone please tell me what the problem is?

Re: table size is not changed

От

Grzegorz Jaśkiewicz

Дата:

03 февраля 2010 г., 05:47:57

try reindexing table.

Re: table size is not changed

От

Scott Marlowe

Дата:

03 февраля 2010 г., 05:49:23

On Wed, Feb 3, 2010 at 2:43 AM, AI Rumman <rummandba@gmail.com> wrote:
> I deleted 70000 rows from a table and then execute
> vacuum analyze <table>.
>
> But table size not yet changed.
>
> I am using Postgresql 8.1.
>
> Could anyone please tell me what the problem is?


http://www.postgresql.org/docs/8.1/static/maintenance.html#VACUUM-FOR-SPACE-RECOVERY

explains it pretty well.

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Обсуждение: table size is not changed

table size is not changed

Re: table size is not changed

Re: table size is not changed