Provided by: pgtune_0.9.3-1_all bug


       pgtune - generate an optimized postgresql.conf file


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


       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.


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


       pgtune was written by Gregory Smith.

       This    manual    page    was    written    by   Rodolphe   Quiédeville
       <>, for the Debian project (and may be used  by

                               November  2, 2009                     PGTUNE(1)