Skip site navigation (1) Skip section navigation (2)

Re: autovacuum doesn't seem to vacuum pg_attribute

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Martin Pitt <martin(at)piware(dot)de>
Cc: PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: autovacuum doesn't seem to vacuum pg_attribute
Date: 2005-09-22 02:59:37
Message-ID: 23869.1127357977@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Martin Pitt <martin(at)piware(dot)de> writes:
> While cleaning up the postgresql bug reports in Debian, I stumbled
> over the following gem. Do you know about this problem, and is it
> still an issue for 8.0 and 8.1?

Probably fixed here:

2005-03-31 18:20  tgl

	* src/backend/postmaster/: pgstat.c (REL7_4_STABLE), pgstat.c
	(REL8_0_STABLE), pgstat.c: Flush any remaining statistics counts
	out to the collector at process exit.  Without this, operations
	triggered during backend exit (such as temp table deletions) won't
	be counted ... which given heavy usage of temp tables can lead to
	pg_autovacuum falling way behind on the need to vacuum pg_class and
	pg_attribute.  Per reports from Steve Crawford and others.

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Alvaro HerreraDate: 2005-09-22 14:40:13
Subject: Re: possible bug...
Previous:From: Brian CoxDate: 2005-09-21 23:12:55
Subject: BUG #1904: using distinct with null col causes error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group