Thread: pg_autovacuum README patch

pg_autovacuum README patch

From
Gaetano Mendola
Date:
--- 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")


Re: pg_autovacuum README patch

From
Gaetano Mendola
Date:
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


Re: pg_autovacuum README patch

From
Bruce Momjian
Date:
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