Обсуждение: autovacuum check

Поиск
Список
Период
Сортировка

autovacuum check

От
Anj Adu
Дата:
We are using postgres 8.4.x on a few boxes.

Is there a way to check if autovac vacuumed a particular table?

Re: autovacuum check

От
Devrim GÜNDÜZ
Дата:
See pg_stat_user_tables table.

--
Devrim GÜNDÜZ
PostgreSQL DBA @ Akinon/Markafoni, Red Hat Certified Engineer
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

18.Ağu.2010 tarihinde 18:30 saatinde, Anj Adu <fotographs@gmail.com>
şunları yazdı:

> We are using postgres 8.4.x on a few boxes.
>
> Is there a way to check if autovac vacuumed a particular table?
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin

Re: autovacuum check

От
Anj Adu
Дата:
Thanks..all the info is present in the table

2010/8/18 Devrim GÜNDÜZ <devrim@gunduz.org>:
> See pg_stat_user_tables table.
>
> --
> Devrim GÜNDÜZ
> PostgreSQL DBA @ Akinon/Markafoni, Red Hat Certified Engineer
> devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
> http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz
>
> 18.Ağu.2010 tarihinde 18:30 saatinde, Anj Adu <fotographs@gmail.com> şunları
> yazdı:
>
>> We are using postgres 8.4.x on a few boxes.
>>
>> Is there a way to check if autovac vacuumed a particular table?
>>
>> --
>> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>