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