Re: Table not getting vaccumed.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Table not getting vaccumed.
Дата
Msg-id 13551.1159634750@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Table not getting vaccumed.  ("Nimesh Satam" <nimesh.zedo@gmail.com>)
Список pgsql-performance
"Nimesh Satam" <nimesh.zedo@gmail.com> writes:
> I am trying to vaccum one of the table using the following command:
> VACUUM FULL ANALYZE VERBOSE table_name;
> But for some reason the table vaccuming is not going ahead.

VACUUM FULL requires exclusive lock on the table, so it's probably
waiting for some open transaction that has a reader's or writer's
lock on it.  Look in pg_stat_activity and pg_locks to find out more.

            regards, tom lane

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

Предыдущее
От: Markus Schaber
Дата:
Сообщение: Re: how to optimize postgres 8.1
Следующее
От: Steve Martin
Дата:
Сообщение: selecting data from information_schema.columns performance.