| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Bryan Payne <bpayne(at)speedfc(dot)com> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Autovacuum missing tables |
| Date: | 2010-07-30 15:39:30 |
| Message-ID: | 1280504209-sup-9681@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Excerpts from Bryan Payne's message of vie jul 30 11:10:42 -0400 2010:
> Table info (this table shows last autovacuum on 7/28):
> hostname=> VACUUM ANALYZE VERBOSE hierarchy_pull;
> INFO: vacuuming "public.hierarchy_pull"
> INFO: "hierarchy_pull": found 0 removable, 1906 nonremovable row
> versions in 78 pages
> DETAIL: 0 dead row versions cannot be removed yet.
Eh, this says that this table didn't need a vacuum at all (no removable
rows). Maybe that's why autovacuum didn't process it?
--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bryan Payne | 2010-07-30 15:44:02 | Re: Autovacuum missing tables |
| Previous Message | Benjamin Krajmalnik | 2010-07-30 15:38:33 | Re: Autovacuum missing tables |