Thread: minor readme patch for pg_autovacuum

minor readme patch for pg_autovacuum

From
Andrew Dunstan
Date:
The attached patch for contrib/pg_autovacuum/README.pg_autovacuum fixes
one apparent error and makes a minor stylistic change that makes it more
consistent and makes clear something that confused me :-)

cheers

andrew
Index: contrib/pg_autovacuum/README.pg_autovacuum
===================================================================
RCS file: /projects/cvsroot/pgsql-server/contrib/pg_autovacuum/README.pg_autovacuum,v
retrieving revision 1.6
diff -c -r1.6 README.pg_autovacuum
*** contrib/pg_autovacuum/README.pg_autovacuum    9 Nov 2003 03:15:46 -0000    1.6
--- contrib/pg_autovacuum/README.pg_autovacuum    19 Apr 2004 15:51:00 -0000
***************
*** 110,119 ****
  -D daemonize: Detach from tty and run in background.
  -s sleep base value: see "Sleeping" below.
  -S sleep scaling factor: see "Sleeping" below.
! -v vacuum base threshold: see Vacuum and Analyze.
! -V vacuum scaling factor: see Vacuum and Analyze.
! -a analyze base threshold: see Vacuum and Analyze.
! -A analyze scaling factor: see Vacuum and Analyze.
  -L log file: Name of file to which output is submitted, otherwise STDERR
  -U username: Username pg_autovacuum will use to connect with, if not
     specified the current username is used.
--- 110,119 ----
  -D daemonize: Detach from tty and run in background.
  -s sleep base value: see "Sleeping" below.
  -S sleep scaling factor: see "Sleeping" below.
! -v vacuum base threshold: see "Vacuum and Analyze" below.
! -V vacuum scaling factor: see "Vacuum and Analyze" below.
! -a analyze base threshold: see "Vacuum and Analyze" below.
! -A analyze scaling factor: see "Vacuum and Analyze" below.
  -L log file: Name of file to which output is submitted, otherwise STDERR
  -U username: Username pg_autovacuum will use to connect with, if not
     specified the current username is used.
***************
*** 129,135 ****
  -v 1000
  -V 2
  -a 500 (half of -v if not specified)
! -A 1   (half of -v if not specified)
  -s 300 (5 minutes)
  -S 2

--- 129,135 ----
  -v 1000
  -V 2
  -a 500 (half of -v if not specified)
! -A 1   (half of -V if not specified)
  -s 300 (5 minutes)
  -S 2


Re: minor readme patch for pg_autovacuum

From
"Matthew T. O'Connor"
Date:
Andrew Dunstan wrote:

>***************
>*** 129,135 ****
>  -v 1000
>  -V 2
>  -a 500 (half of -v if not specified)
>! -A 1   (half of -v if not specified)
>  -s 300 (5 minutes)
>  -S 2
>
>--- 129,135 ----
>  -v 1000
>  -V 2
>  -a 500 (half of -v if not specified)
>! -A 1   (half of -V if not specified)
>  -s 300 (5 minutes)
>  -S 2
>

Oops... good catch.

Re: minor readme patch for pg_autovacuum

From
Bruce Momjian
Date:
Patch applied.  Thanks.

---------------------------------------------------------------------------


Andrew Dunstan wrote:
>
> The attached patch for contrib/pg_autovacuum/README.pg_autovacuum fixes
> one apparent error and makes a minor stylistic change that makes it more
> consistent and makes clear something that confused me :-)
>
> cheers
>
> andrew

> Index: contrib/pg_autovacuum/README.pg_autovacuum
> ===================================================================
> RCS file: /projects/cvsroot/pgsql-server/contrib/pg_autovacuum/README.pg_autovacuum,v
> retrieving revision 1.6
> diff -c -r1.6 README.pg_autovacuum
> *** contrib/pg_autovacuum/README.pg_autovacuum    9 Nov 2003 03:15:46 -0000    1.6
> --- contrib/pg_autovacuum/README.pg_autovacuum    19 Apr 2004 15:51:00 -0000
> ***************
> *** 110,119 ****
>   -D daemonize: Detach from tty and run in background.
>   -s sleep base value: see "Sleeping" below.
>   -S sleep scaling factor: see "Sleeping" below.
> ! -v vacuum base threshold: see Vacuum and Analyze.
> ! -V vacuum scaling factor: see Vacuum and Analyze.
> ! -a analyze base threshold: see Vacuum and Analyze.
> ! -A analyze scaling factor: see Vacuum and Analyze.
>   -L log file: Name of file to which output is submitted, otherwise STDERR
>   -U username: Username pg_autovacuum will use to connect with, if not
>      specified the current username is used.
> --- 110,119 ----
>   -D daemonize: Detach from tty and run in background.
>   -s sleep base value: see "Sleeping" below.
>   -S sleep scaling factor: see "Sleeping" below.
> ! -v vacuum base threshold: see "Vacuum and Analyze" below.
> ! -V vacuum scaling factor: see "Vacuum and Analyze" below.
> ! -a analyze base threshold: see "Vacuum and Analyze" below.
> ! -A analyze scaling factor: see "Vacuum and Analyze" below.
>   -L log file: Name of file to which output is submitted, otherwise STDERR
>   -U username: Username pg_autovacuum will use to connect with, if not
>      specified the current username is used.
> ***************
> *** 129,135 ****
>   -v 1000
>   -V 2
>   -a 500 (half of -v if not specified)
> ! -A 1   (half of -v if not specified)
>   -s 300 (5 minutes)
>   -S 2
>
> --- 129,135 ----
>   -v 1000
>   -V 2
>   -a 500 (half of -v if not specified)
> ! -A 1   (half of -V if not specified)
>   -s 300 (5 minutes)
>   -S 2
>

>
> ---------------------------(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