Question regarding autovacuum in 8.1
От | Denis Gasparin |
---|---|
Тема | Question regarding autovacuum in 8.1 |
Дата | |
Msg-id | 46D54794.1040208@edistar.com обсуждение исходный текст |
Ответ на | Re: Question regarding autovacuum (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-general |
How is it possibile to check if autovacuum is running in 8.1.x? "Show Autovacuum" gives me on and also i see evidence in logs where autovacuum writes "LOG: autovacuum: processing database xxxx". However i have no idea of what tables the autovacuum daemon is processing because there aren't autovacuum info columns on pg_stat_all_tables (as there are for 8.2.x). Also I'm asking this because the size of the pg_clog is >200M and I am worried about possible transaction ID wraparound failures... Thank you, Denis Tom Lane ha scritto: > Karl Denninger <karl@denninger.net> writes: > >> But... .shouldn't autovacuum prevent this? Is there some way to look in >> a log somewhere and see if and when the autovacuum is being run - and on >> what? >> > > There's no log messages (at the default log verbosity anyway). But you > could look into the pg_stat views for the last vacuum time for each table. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend > >
В списке pgsql-general по дате отправления: