Page History

...

12. Run pgtune. Note that this requires Python. If you are using PostgreSQL version 9.4 and above, you can use the online tool https://pgtune.leopard.in.ua/#/ and fill in the required values as well as those that correspond to your system. Add or change the appropriate settings and restart PostgreSQL.

# For PostgreSQL > 9.4, use the online tool and paste added configuration options at end of postgres.conf 

# For CentOS 7 and PostgreSQL < 9.4 only:

yum -y install pgtune
  pgtune -i postgresql.conf  -T DW -c 500

# If using the online tool, paste added configuration options at end of postgres.conf

13. Run the pre-flight check script to confirm that your system is properly configured to load the data.

...