PgTune PgTune

PgTune PgTune

Configuration calculator for PostgreSQL

PGTune calculate configuration for PostgreSQL based on the maximum performance for a given hardware configuration. It isn't a silver bullet for the optimization settings of PostgreSQL. Many settings depend not only on the hardware configuration, but also on the size of the database, the number of clients and the complexity of queries, so that optimally configure the database can only be given all these parameters.

Working offline and as mobile app.

Parameters of your system

PostgreSQL settings (add/modify this settings in postgresql.conf and restart database):

Set "Total Memory" and click "Generate" button

Or you can use ALTER SYSTEM SET command:

NOTICE: For PostgreSQL 9.3 you also should modify kernel resources (add this in /etc/sysctl.conf):