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)