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 [EMAIL PROTECTED] > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (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
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])