PostgreSQL 參數值、調整調校建議的 Script

PostgreSQL 要做哪些設定，值要設定多少？這個 Script 可以協助給一些建議~~

PostgreSQL 參數值、調整調校建議的 Script

MySQL 一樣的東西可見此篇：MySQL 參數值 調整建議的 Script

• GitHub - major/MySQLTuner-perl: MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability.

PostgreSQL 的 Tune Script

• GitHub - jfcoz/postgresqltuner: Simple script to analyse your PostgreSQL database configuration, and give tuning advice
• GitHub：PGTune - calculate configuration for PostgreSQL based on the maximum performance for a given hardware configuration

PostgreSQLTuner 安裝、使用方式

1. apt install libdbd-pg-perl libdbi-perl perl-modules
2. PostgreSQLTuner 安裝、使用方式
3. 挑其一
   • wget -O postgresqltuner.pl https://postgresqltuner.pl
   • curl -Lo postgresqltuner.pl https://postgresqltuner.pl
4. chmod +x ./postgresqltuner.pl
5. sudo -u postgres ./postgresqltuner.pl
6. postgresqltuner.pl --host=dbhost --database=testdb --user=your-username --password=your-password