CI Decomposition Performance Summary

The purpose of this issue is to compare before and after decomposition in various aspects observed.

This will be extended over time. Each thread represents a single metric observed.

Gathered results are preliminary.

What data shows?

Main

• Main has about 1.666x headroom in terms of CPU/connections (30% to 50%, and 230 to 360)
• Around 1.8x in terms of disk space to pre-decomposition levels (12.7TiB to 22TiB)
• Grows slower than CI at around 300-350GB a 4wks
• Has 5-6x vacuuming capacity (80% to 15%). However, this is non-linear, so depending whether this is a single big table or a few smaller ones this might be a different number.

CI

• CI has about 3x headroom in terms of CPU/connections (15% to 50%, and 160 to 360 connections)
• 2-2.5x in terms of disk space to pre-decomposition levels (9.24TiB to 22.4TiB)
• Grows faster than Main at around 600-700GB a 4wks
• Has 5-6x vacuuming capacity (80% to 15%)