Re: Dumb question - how to tell if autovacuum is doing its job in 8.2.x
| От | Shoaib Mir |
|---|---|
| Тема | Re: Dumb question - how to tell if autovacuum is doing its job in 8.2.x |
| Дата | |
| Msg-id | bf54be870702122227p317c0210h6a34d28587f98f8c@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Dumb question - how to tell if autovacuum is doing its job in 8.2.x (Walter Vaughan <wvaughan@steelerubber.com>) |
| Список | pgsql-general |
Make sure you have stats collector enabled, if auto vacuum is doing the analyze and vacuum it should be recording that info in this view. For details on this you can have a look at --> http://www.postgresql.org/docs/8.2/interactive/monitoring-stats.html
Just for a test try doing a VACUUM or ANALYZE manually and see if that gets updated in the last_vacuum of pg_stats_all_tables.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
Just for a test try doing a VACUUM or ANALYZE manually and see if that gets updated in the last_vacuum of pg_stats_all_tables.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 2/13/07, Walter Vaughan < wvaughan@steelerubber.com> wrote:
Shoaib Mir wrote:
> pg_stat_all_table view should help you:
>
> select last_autovacuum, last_autoanalyze from pg_stat_all_tables;
select last_autovacuum, last_autoanalyze from pg_stat_all_tables;
last_autovacuum | last_autoanalyze
-----------------+------------------
|
...snip lots of identically blank lines...
|
|
(939 rows)
Does that mean it's working or not configured right?
Thanks,
Walter
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
В списке pgsql-general по дате отправления: