この記事の内容
PostgreSQLのサーバーパラメーター（GUC）について、カテゴリーごと、バージョンごとにカウントしてみました。
背景
2020年2月13日に、PostgreSQL 9.4の開発コミュニティによるサポートが終了します。
PostgreSQL 9.4から上位バージョンへのバージョンアップをおこなう際の非互換調査のひとつとして、まずはサーバーパラメーターについて確認してみます。
調査方法
SELECT category, count(category) FROM pg_settings GROUP BY category ORDER BY category;
結果
PostgreSQL 12は、PostgreSQL 9.4にくらべて1.3倍、74個も増えています。
バージョンが上がるにつれて、パラメーター数も確実に多くなっていますね。
単純に考えても、その増えた分について把握、検討が必要ということです。
| category | 9.4.25 | 9.5.20 | 9.6.16 | 10.11 | 11.6 | 12.1 |
|---|---|---|---|---|---|---|
| Autovacuum | 11 | 11 | 11 | 11 | 11 | 11 |
| Client Connection Defaults / Locale and Formatting |
14 | 14 | 14 | 14 | 14 | 14 |
| Client Connection Defaults / Other Defaults |
5 | 5 | 5 | 5 | 5 | 6 |
| Client Connection Defaults / Shared Library Preloading |
3 | 3 | 3 | 3 | 4 | 4 |
| Client Connection Defaults / Statement Behavior |
21 | 22 | 23 | 23 | 25 | 26 |
| Connections and Authentication / Authentication |
5 | 5 | ||||
| Connections and Authentication / Connection Settings |
9 | 9 | 9 | 9 | 9 | 9 |
| Connections and Authentication / Security and Authentication |
14 | 14 | 14 | 15 | ||
| Connections and Authentication / SSL |
11 | 13 | ||||
| Developer Options | 10 | 9 | 9 | 10 | 15 | 15 |
| Error Handling | 3 | 3 | 3 | 3 | 3 | 3 |
| File Locations | 5 | 5 | 5 | 5 | 5 | 5 |
| Lock Management | 3 | 3 | 3 | 5 | 5 | 5 |
| Preset Options | 11 | 12 | 12 | 12 | 13 | 14 |
| Process Title | 2 | 2 | 2 | 2 | 2 | |
| Query Tuning / Genetic Query Optimizer |
7 | 7 | 7 | 7 | 7 | 7 |
| Query Tuning / Other Planner Options |
5 | 5 | 6 | 6 | 7 | 8 |
| Query Tuning / Planner Cost Constants |
6 | 6 | 9 | 10 | 13 | 13 |
| Query Tuning / Planner Method Configuration |
11 | 11 | 11 | 12 | 17 | 17 |
| Replication | 1 | 1 | 1 | 1 | 1 | |
| Replication / Master Server |
2 | 2 | 2 | 2 | 2 | 2 |
| Replication / Sending Servers |
4 | 4 | 4 | 4 | 4 | 4 |
| Replication / Standby Servers |
6 | 7 | 7 | 7 | 7 | 11 |
| Replication / Subscribers |
2 | 2 | 2 | |||
| Reporting and Logging / What to Log |
17 | 18 | 18 | 18 | 18 | 18 |
| Reporting and Logging / When to Log |
3 | 3 | 3 | 3 | 3 | 4 |
| Reporting and Logging / Where to Log |
11 | 11 | 13 | 13 | 13 | 13 |
| Resource Usage / Asynchronous Behavior |
2 | 2 | 5 | 6 | 8 | 8 |
| Resource Usage / Background Writer |
3 | 3 | 4 | 4 | 4 | 4 |
| Resource Usage / Cost-Based Vacuum Delay |
5 | 5 | 5 | 5 | 5 | 5 |
| Resource Usage / Disk |
1 | 1 | 1 | 1 | 1 | 1 |
| Resource Usage / Kernel Resources |
1 | 1 | 1 | 1 | 1 | 1 |
| Resource Usage / Memory |
10 | 10 | 11 | 11 | 10 | 11 |
| Statistics / Monitoring |
4 | 4 | 4 | 4 | 4 | 4 |
| Statistics / Query and Index Statistics Collector |
6 | 5 | 5 | 5 | 5 | 5 |
| Version and Platform Compatibility / Other Platforms and Clients |
1 | 1 | 1 | 1 | 1 | 1 |
| Version and Platform Compatibility / Previous PostgreSQL Versions |
9 | 10 | 10 | 9 | 9 | 8 |
| Write-Ahead Log / Archive Recovery |
3 | |||||
| Write-Ahead Log / Archiving |
3 | 3 | 3 | 3 | 3 | 3 |
| Write-Ahead Log / Checkpoints |
4 | 5 | 6 | 6 | 6 | 6 |
| Write-Ahead Log / Recovery Target |
8 | |||||
| Write-Ahead Log / Settings |
10 | 11 | 12 | 12 | 12 | 14 |
| 合計 | 240 | 248 | 262 | 270 | 290 | 314 |