Single-Node and Cluster Performance Comparison (PostgreSQL only)
|
|||||
---|---|---|---|---|---|
Foundation
|
1 × F16s_v2
|
2 × F16s_v2
|
3 × F16s_v2
|
4 × F16s_v2
|
5 × F16s_v2
|
Ignite
|
None
|
3 × F8s_v2
|
3 × F8s_v2
|
3 × F8s_v2
|
3 × F8s_v2
|
PostgreSQL
|
1 × F16s_v2
|
1 × F16s_v2
|
1 × F16s_v2
|
1 × F16s_v2
|
1 × F16s_v2
|
InfluxDB
|
None
|
None
|
None
|
None
|
None
|
Results Per Node (Avg.)
|
26,000 WPS
19 HTTP Ops
|
12,000 WPS
10 HTTP Ops
|
10,000 WPS
6 HTTP Ops
|
7,000 WPS
6 HTTP Ops
|
6,000 WPS
2 HTTP Ops
|
Results Total
|
24,000 WPS
19 HTTP Ops
|
30,000 WPS
24 HTTP Ops
|
28,000 WPS
22 HTTP Ops
|
30,000 WPS
12 HTTP Ops
|
|
Reminder: Sizing Guide recommendations are intended for use initial baselines to size ThingWorx implementations. Individual results will vary based on edge configuration, application load, etc.
|
Single-Node and Cluster Performance Comparison (PostgreSQL + InfluxDB)
|
|||||
---|---|---|---|---|---|
Foundation
|
1 × F16s_v2
|
2 × F16s_v2
|
3 × F16s_v2
|
4 × F16s_v2
|
5 × F16s_v2
|
Ignite
|
None
|
3 × F8s_v2
|
3 × F8s_v2
|
3 × F8s_v2
|
3 × F8s_v2
|
PostgreSQL
|
1 × F8s_v2
|
1 × F8s_v2
|
1 × F8s_v2
|
1 × F8s_v2
|
1 × F8s_v2
|
InfluxDB
|
1 × F8s_v2
|
1 × F8s_v2
|
1 × F8s_v2
|
1 × F8s_v2
|
1 × F8s_v2
|
Results Per Node (Avg.)
|
90,000 WPS
120 HTTP Ops
|
53,000 WPS
187 HTTP Ops
|
39,000 WPS
148 HTTP Ops
|
31,500 WPS
127 HTTP Ops
|
27,000 WPS
108 HTTP Ops
|
Results Total
|
106,000 WPS
375 HTTP Ops
|
118,000 WPS
445 HTTP Ops
|
126,000 WPS
508 HTTP Ops
|
135,000 WPS
540 HTTP Ops
|
|
Reminder: Sizing Guide recommendations are intended for use initial baselines to size ThingWorx implementations. Individual results will vary based on edge configuration, application load, etc.
|
|
InfluxDB open source was used for these tests, which does not provide high availability. InfluxDB Enterprise would be recommended for production ThingWorx cluster implementations. For InfluxDB Enterprise sizing, plan for two InfluxDB “Data” nodes as indicated, plus three “Meta” nodes, typically 1-2 vCPUs and 0.5-1GiB RAM each. For more guidance on InfluxDB sizing, please review https://docs.influxdata.com/influxdb/v1.8/guides/hardware_sizing/.
|