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