Configure Your Database for Better Performance
- 48 Downloads
In the last chapter, we talked about information that needed to be gathered for PostgreSQL installation, and planning installation based on that information. Also, we covered types of PostgreSQL installations, pre/post-installation tuning, troubleshooting procedures, and some general recommendations to consider during installation to avoid performance issues in future. In this chapter, we will cover some initial postinstallation steps for beginners, all important configuration files and their uses and their default settings, recommendations to tune configuration files, and OS parameters tuning for performance improvement.