pypgoptimizator 1.2

Postgresql configuration optimizator

Contents

• README

  • BASIC USAGE

  • HELP

  • Parameters

README

This script some optimized parameters in a postgresql configuration file according to the current machine possibilities and parameters given on the command line.

BASIC USAGE

pypgoptimizator -i pg.conf -o new.pg.conf

HELP

pypgoptimizator –help

Parameters

• -b: The shared buffer size. It’s 8192 by default, and it can be changed at compilation time, pgsql side.

• -l: The output logs filename scheme (log_filename paramater)

• -o: The output file to write into

• -i: The input postgresql configuration file to read info from

• -m: max connections parameter for postgres (default 100)

• -p: The availaible Memory in KBytes, defaults to all available memory