Provided by: pgtune_0.9.3-1_all
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.
Specifies the current postgresql.conf file.
Specifies the file name for the new postgresql.conf file.
Use this parameter to specify total system memory. If not
specified, pgtune will attempt to detect memory size.
Specifies database type. Valid options are: DW, OLTP, Web,
Specifies number of maximum connections expected. If not
specified, it depends on database type.
Enables debugging mode.
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.
Show summary of options.
Show version of program.
pgtune was written by Gregory Smith.
This manual page was written by Rodolphe Quiédeville
<firstname.lastname@example.org>, for the Debian project (and may be used by
November 2, 2009 PGTUNE(1)