Re: pg_autovacuum README patch
От | Bruce Momjian |
---|---|
Тема | Re: pg_autovacuum README patch |
Дата | |
Msg-id | 200311090315.hA93FNI12000@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Re: pg_autovacuum README patch (Gaetano Mendola <mendola@bigfoot.com>) |
Список | pgsql-patches |
Yes, I have reverted the lines outlined below and am attaching the patch. --------------------------------------------------------------------------- Gaetano Mendola wrote: > Gaetano Mendola wrote: > > > > > ------------------------------------------------------------------------ > > > > --- README.good 2003-10-21 02:40:19.000000000 +0200 > > +++ README 2003-10-21 02:37:43.000000000 +0200 > > @@ -1,3 +1,3 @@ > > -PG_autovacuum README > > +pg_autovacuum README > > -------------------- > > > > @@ -148,8 +148,8 @@ > > vacuum analyze is performed. > > > > -AnalyzeThreshold is equal to: > > +deleteThreshold is equal to: > > vacuum_base_value + (vacuum_scaling_factor * "number of tuples in the table") > > > > -VacuumThreshold is equal to: > > +insertThreshold is equal to: > > analyze_base_value + (analyze_scaling_factor * "number of tuples in the table") > > Was I wrong ? > > Regards > Gaeatano Mendola > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 Index: contrib/pg_autovacuum/README.pg_autovacuum =================================================================== RCS file: /cvsroot/pgsql-server/contrib/pg_autovacuum/README.pg_autovacuum,v retrieving revision 1.5 diff -c -c -r1.5 README.pg_autovacuum *** contrib/pg_autovacuum/README.pg_autovacuum 16 Oct 2003 03:47:28 -0000 1.5 --- contrib/pg_autovacuum/README.pg_autovacuum 9 Nov 2003 03:10:53 -0000 *************** *** 147,156 **** - If the number of (deletes + updates) > VacuumThreshold, then a vacuum analyze is performed. ! deleteThreshold is equal to: vacuum_base_value + (vacuum_scaling_factor * "number of tuples in the table") ! insertThreshold is equal to: analyze_base_value + (analyze_scaling_factor * "number of tuples in the table") The AnalyzeThreshold defaults to half of the VacuumThreshold since it --- 147,156 ---- - If the number of (deletes + updates) > VacuumThreshold, then a vacuum analyze is performed. ! VacuumThreshold is equal to: vacuum_base_value + (vacuum_scaling_factor * "number of tuples in the table") ! AnalyzeThreshold is equal to: analyze_base_value + (analyze_scaling_factor * "number of tuples in the table") The AnalyzeThreshold defaults to half of the VacuumThreshold since it
В списке pgsql-patches по дате отправления: