Re: [HACKERS] Autovacuum loose ends - Mailing list pgsql-patches

From Alvaro Herrera
Subject Re: [HACKERS] Autovacuum loose ends
Date
Msg-id 20050810173332.GA8752@alvh.no-ip.org
Whole thread Raw
In response to Re: [HACKERS] Autovacuum loose ends  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: [HACKERS] Autovacuum loose ends  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
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.

Note that I had to add datvacuumxid to the pg_database flat file.

--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"Ciencias políticas es la ciencia de entender por qué
 los políticos actúan como lo hacen"  (netfunny.com)

Attachment

pgsql-patches by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: COPY FROM performance improvements
Next
From: Simon Riggs
Date:
Subject: Re: (was COPY FROM) performance improvements