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
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin