Обсуждение: 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?
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
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 >