1PGTUNE(8)                                                            PGTUNE(8)
2
3
4

NAME

6       pgtune - PostgreSQL Config Tuner
7

SYNOPSIS

9       pgtune -i $PGDATA/postgresql.conf -o $PGDATA/postgresql.conf.pgtune
10

DESCRIPTION

12       Pgtune takes the wimpy default postgresql.conf and expands the database
13       server to be as powerful as the hardware it’s being deployed on.
14
15       pgtune works by taking an existing postgresql.conf file as an input,
16       making changes to it based on the amount of RAM in your server and
17       suggested workload, and output a new file.
18

OPTIONS

20       -i, --input-config
21           Specifies the current postgresql.conf file.
22
23       -o, --input-config
24           Specifies the file name for the new postgresql.conf file.
25
26       -M, --memory
27           Use this parameter to specify total system memory. If not
28           specified, pgtune will attempt to detect memory size.
29
30       -T, --type
31           Specifies database type. Valid options are: DW, OLTP, Web, Mixed,
32           Desktop
33
34       -c, --connections
35           Specifies number of maximum connections expected. If not specified,
36           it depends on database type.
37
38       -D, --debug
39           Enables debugging mode.
40
41       -S, --settings
42           Directory where settings data files are located at. Defaults to the
43           directory where the script is being run from. The RPM package
44           includes a patch to use the correct location these files were
45           installed into.
46

SEE ALSO

48       postgres(1)
49

AUTHORS

51       This man page is written by Miroslav Suchy for Fedora.
52
53
54
55                                  07/15/2018                         PGTUNE(8)