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.
PostgreSQL settings (add/modify this settings in postgresql.conf and restart database):
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):