Re: How can I tell if I'm autovacuuming?

Поиск
Список
Период
Сортировка
От Mitch Collinsworth
Тема Re: How can I tell if I'm autovacuuming?
Дата
Msg-id Pine.LNX.4.62.1005251533410.11199@mirror.ccmr.cornell.edu
обсуждение исходный текст
Ответ на Re: How can I tell if I'm autovacuuming?  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Ответы Re: How can I tell if I'm autovacuuming?  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-admin


On Tue, 25 May 2010, Alvaro Herrera wrote:

> Excerpts from Mitch Collinsworth's message of mar may 25 14:40:04 -0400 2010:
>
>> I'm wondering about the same question.  I did the above and restarted,
>> and now my pg_stat_user_tables looks like this:
>>
>> postgres=# \d pg_stat_user_tables
>> View "pg_catalog.pg_stat_user_tables"
>>      Column     |  Type  | Modifiers
>> ---------------+--------+-----------
>>   relid         | oid    |
>>   schemaname    | name   |
>>   relname       | name   |
>>   seq_scan      | bigint |
>>   seq_tup_read  | bigint |
>>   idx_scan      | bigint |
>>   idx_tup_fetch | bigint |
>>   n_tup_ins     | bigint |
>>   n_tup_upd     | bigint |
>>   n_tup_del     | bigint |
>
> I'd say you're running 8.1, not 8.2 as initially stated.

Well...  yes.  Sorry.    I take it the answer is different then...

So...  How can I tell if I'm autovacuuming in 8.1.21?

-Mitch

В списке pgsql-admin по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: How can I tell if I'm autovacuuming?
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: How can I tell if I'm autovacuuming?