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@xxxxxxxxxxxxxxxxx> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
