autovacuum check
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 [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Re: autovacuum check
See pg_stat_user_tables table.
--
Devrim G=C3=9CND=C3=9CZ
PostgreSQL DBA [at] 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=C4=9Fu.2010 tarihinde 18:30 saatinde, Anj Adu <fotographs [at] gmail.com>=
=C5=9Funlar=C4=B1 yazd=C4=B1:
> 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 [at] postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Re: autovacuum check
Thanks..all the info is present in the table
2010/8/18 Devrim G=C3=9CND=C3=9CZ <devrim [at] gunduz.org>:
> See pg_stat_user_tables table.
>
> --
> Devrim G=C3=9CND=C3=9CZ
> PostgreSQL DBA [at] Akinon/Markafoni, Red Hat Certified Engineer
> devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
> http://www.gunduz.org =C2=A0Twitter: http://twitter.com/devrimgunduz
>
> 18.A=C4=9Fu.2010 tarihinde 18:30 saatinde, Anj Adu <fotographs [at] gmail.com>=
=C5=9Funlar=C4=B1
> yazd=C4=B1:
>
>> 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 [at] postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>
--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin