From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "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-08 17:38:58 |
Message-ID: | 20050808173858.GA12487@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
On Sun, Jul 31, 2005 at 07:36:36PM -0400, Alvaro Herrera wrote:
Updated this patch:
> - 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
--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"No hay cielo posible sin hundir nuestras raíces
en la profundidad de la tierra" (Malucha Pinto)
Attachment | Content-Type | Size |
---|---|---|
autovac-three-2.patch | text/plain | 29.4 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2005-08-08 17:41:54 | Re: Remote administration functionality |
Previous Message | Tom Lane | 2005-08-08 16:25:25 | Re: shrinking the postgresql.conf |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2005-08-08 20:26:37 | Re: Implementing SELECT FOR UPDATE [NOWAIT] |
Previous Message | Tom Lane | 2005-08-08 14:36:50 | Re: enable/disable trigger (Re: Fwd: [HACKERS] Open items) |