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

Re: [HACKERS] Autovacuum loose ends

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: pgsql-patches(at)postgresql(dot)org
Subject: Re: [HACKERS] Autovacuum loose ends
Date: 2005-07-29 19:48:05
Message-ID: 20050729194805.GC16537@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
On Fri, Jul 29, 2005 at 03:33:09PM -0400, Tom Lane wrote:
> Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> writes:
> > Updated this patch:
> > - The stat collector is modified so as to keep shared relations separate
> >   from regular ones.  Autovacuum understands this.
> >   [etc]
> 
> Applied with some fixes --- you had broken the reporting of statistics
> for shared tables, for one thing.

Oops :-(  Didn't notice that.

> Also the patch seemed to be missing diffs for header files?

Damn, I generated the diff from within src/backend instead of the root
:-(  Sorry for the inconvenience.

> It occurs to me that vacuuming to prevent XID wraparound is not the only
> reason to do DB-wide vacuums: we also need to keep
> pg_database.datvacuumxid from getting too old, else we will have
> problems with clog bloat.  We may need to rethink the test used.

Hmm.  Will see about it.

-- 
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"La Primavera ha venido. Nadie sabe como ha sido" (A. Machado)

In response to

Responses

pgsql-hackers by date

Next:From: Mark WongDate: 2005-07-29 19:51:57
Subject: Re: [Testperf-general] dbt2 & opteron performance
Previous:From: Jim C. NasbyDate: 2005-07-29 19:39:08
Subject: Re: [Testperf-general] dbt2 & opteron performance

pgsql-patches by date

Next:From: Matt MillerDate: 2005-07-29 20:18:14
Subject: PL/pgSQL: SELECT INTO EXACT
Previous:From: Tom LaneDate: 2005-07-29 19:33:09
Subject: Re: [HACKERS] Autovacuum loose ends

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