Sizing guidelines for storage capacity on Postgres systems
When sizing storage capacity for a PostgreSQL system, you need to consider the following PostgreSQL database components:
- Database files
- Transaction log files
- Backup
Storage capacity
Database element | Space requirement | 20,000 nodes | 50,000 nodes | 100,000 nodes | 150,000 nodes | 200,000 nodes |
|---|---|---|---|---|---|---|
Database files | DB size | 20 GB | 50 GB | 100 GB | 150 GB | 200 GB |
Transaction log "Wall" | DB size * 0.1 | 2 GB | 5 GB | 10 GB | 15 GB | 20 GB |
Backup | DB size * 0.2 | 4 GB | 10 GB | 20 GB | 30 GB | 40 GB |
Total |
| 26 GB | 65 GB | 130 GB | 145 GB | 260 GB |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*