NAME

       pgtune - generate an optimized postgresql.conf file

SYNOPSIS

       pgtune [ options ] -i $PGDATA/postgresql.conf -o $PGDATA/postgresql.conf.pgtune

DESCRIPTION

       pgtune  takes  the wimpy default postgresql.conf and expands the database server to be as powerful as the
       hardware it's being deployed on.

       pgtune works by taking an existing postgresql.conf file as an input, making changes to it  based  on  the
       amount of RAM in your server and suggested workload, and output a new file.

OPTIONS

       -i, --input-config
              Specifies the current postgresql.conf file.

       -o, --output-config
              Specifies the file name for the new postgresql.conf file.

       -M, --memory
              Use this parameter to specify total system memory. If not specified, pgtune will attempt to detect
              memory size.

       -T, --type
              Specifies database type. Valid options are: DW, OLTP, Web, Mixed, Desktop

       -c, --connections
              Specifies number of maximum connections expected. If not specified, it depends on database type.

       -D, --debug
              Enables debugging mode.

       -S, --settings
              Directory where settings data files are located at.  Defaults to the directory where the script is
              being  run  from.   The  RPM package includes a patch to use the correct location these files were
              installed into.

       -h, --help
              Show summary of options.

       -v, --version
              Show version of program.

AUTHOR

       pgtune was written by Gregory Smith.

       This manual page was written by Rodolphe Quiédeville <rodolphe@quiedeville.org>, for the  Debian  project
       (and may be used by others).

                                                November  2, 2009                                      PGTUNE(1)