| From: | Mitch Collinsworth <mitch(at)ccmr(dot)cornell(dot)edu> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
| Cc: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Doug Gorley <doug(dot)gorley(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: How can I tell if I'm autovacuuming? |
| Date: | 2010-05-25 19:38:38 |
| Message-ID: | Pine.LNX.4.62.1005251533410.11199@mirror.ccmr.cornell.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2010-05-25 19:53:49 | Re: How can I tell if I'm autovacuuming? |
| Previous Message | Alvaro Herrera | 2010-05-25 18:59:37 | Re: How can I tell if I'm autovacuuming? |