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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-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)
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Wong | 2005-07-29 19:51:57 | Re: [Testperf-general] dbt2 & opteron performance |
Previous Message | Jim C. Nasby | 2005-07-29 19:39:08 | Re: [Testperf-general] dbt2 & opteron performance |
From | Date | Subject | |
---|---|---|---|
Next Message | Matt Miller | 2005-07-29 20:18:14 | PL/pgSQL: SELECT INTO EXACT |
Previous Message | Tom Lane | 2005-07-29 19:33:09 | Re: [HACKERS] Autovacuum loose ends |