From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
Cc: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>, pgsql-patches(at)postgresql(dot)org |
Subject: | Re: [HACKERS] Autovacuum loose ends |
Date: | 2005-08-11 21:13:15 |
Message-ID: | 21280.1123794795@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> writes:
> Updated this patch again:
> - vacuum_cost_delay and vacuum_cost_limit can be set per table, as well
> as globally with autovacuum_vacuum_cost_{limit,delay}
>
> - pgstat is reset if recovery is required
>
> - pgstat reset at postmaster start is disabled by default
>
> - Xid-wraparound VACUUM is now FREEZE without ANALYZE, iff the database
> has datallowconn=false or datistemplate=true
>
> - A database-wide vacuum is also issued if the vacuumxid is found to be
> very old.
Applied with minor tweaks --- mostly, fixing it so the custom cost
settings are applied for ANALYZE as well as VACUUM.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2005-08-11 21:18:34 | Re: Simplifying wal_sync_method |
Previous Message | Andrew Sullivan | 2005-08-11 21:09:17 | Re: Race condition in backend process exit |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-08-11 21:43:40 | Re: [HACKERS] For review: Server instrumentation patch |
Previous Message | Bruce Momjian | 2005-08-11 20:36:10 | Re: [HACKERS] O_DIRECT for WAL writes |