Re: [HACKERS] Autovacuum loose ends
От
Alvaro Herrera
Тема
Re: [HACKERS] Autovacuum loose ends
Дата
Msg-id
20050810173332.GA8752@alvh.no-ip.org
Ответ на
Re: [HACKERS] Autovacuum loose ends (Alvaro Herrera)
Список
Дерево обсуждения
Re: [HACKERS] Autovacuum loose ends "Michael Paesold" <mpaesold@gmx.at>
Re: [HACKERS] Autovacuum loose ends Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] Autovacuum loose ends Tom Lane <tgl@sss.pgh.pa.us>
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 ()
"Ciencias políticas es la ciencia de entender por qué
los políticos actúan como lo hacen" (netfunny.com)
В списке pgsql-patches по дате отправления