Re: last_vacuum field is not updating

Поиск
Список
Период
Сортировка
От Giuseppe Broccolo
Тема Re: last_vacuum field is not updating
Дата
Msg-id 51E4269C.1020308@2ndquadrant.it
обсуждение исходный текст
Ответ на last_vacuum field is not updating  (AI Rumman <rummandba@gmail.com>)
Ответы Re: last_vacuum field is not updating  (Luca Ferrari <fluca1978@infinito.it>)
Список pgsql-general
Hi Al,

Il 15/07/2013 16:58, AI Rumman ha scritto:
> Why does vacuum table is not updating the field last_vacuum of
> pg_stat_user_tables?
>
To vacuum a table, one must ordinarily be the table's owner. However,
database owners are allowed to vacuum all tables in their databases.
VACUUM will skip over any tables that the calling user does not have
permission to vacuum.

Are you sure you are the table's owner?

Regards,

Giuseppe.

--
Giuseppe Broccolo - 2ndQuadrant Italy
PostgreSQL Training, Services and Support
giuseppe.broccolo@2ndQuadrant.it | www.2ndQuadrant.it



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

Предыдущее
От: Granthana Biswas
Дата:
Сообщение: Re: Transaction control in shards through PLPROXY
Следующее
От: Bradley McCune
Дата:
Сообщение: Re: V8.4 TOAST table problem