autovacuum check

autovacuum check

am 18.08.2010 17:30:27 von 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?

--
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

am 18.08.2010 17:50:10 von devrim

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 =

ş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?
>
> --=20
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin

--=20
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

am 18.08.2010 18:18:09 von Anj Adu

Thanks..all the info is present in the table

2010/8/18 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 =
ş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
>

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin