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.0 +0200
> > +++ README 2003-10-21 02:37:43.0 +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 - 1.5
--- contrib/pg_autovacuum/README.pg_autovacuum 9 Nov 2003 03:10:53 -
***
*** 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])
