Share
Embed
Slide 1
Slide 1 text
Интересные факты о 500+
инстансов PG наших клиентов
Slide 2
Slide 2 text
PG versions
0
100
200
300
400
500
600
8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10
Slide 3
Slide 3 text
0%
10%
20%
30%
40%
50%
60%
70%
80%
90%
100%
8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10
Slide 4
Slide 4 text
DB size
• Sum = 245 Tb
• Avg = 457 Gb
• Max = 8.5 Tb
• Avg (total_phys_mem:db_size) = 1 : 7
Slide 5
Slide 5 text
Transactions
• Sum = 240 000 TPS
• Commits : rollbacks = 500 : 1
Slide 6
Slide 6 text
WAL
• Sum WAL rate= 250 MB/s (2Gbit/s)
• Max WAL rate = 20MB/s (160Mbit/s)
Slide 7
Slide 7 text
max_connections
• Avg max_conns = 360
• Max max_conns = 3000
• Avg actual connections = 10% (max)
Slide 8
Slide 8 text
Memory
• Avg shared_buffers_size : total_mem = 1 : 3
• Avg buffer cache hit rate = 98 %
• Avg os_page_cache : total_mem = 1 : 2
Slide 9
Slide 9 text
work_mem
• Max = 4G
• (work_mem * max_conns):total_mem = 1.5:1
Slide 10
Slide 10 text
Disk
• Avg disk usage = 50%
• IOPS read : write = 1.8 : 1
• IO traffic read : write = 3 : 1
Slide 11
Slide 11 text
PG + SSD
• SSD стоит в ~20% серверов*
• SSD wearout indicator (S.M.A.R.T):
– Avg = 96.5%
– Min = 55%
Slide 12
Slide 12 text
Самое главное :)
• Средняя температура CPU по больнице
43.8 °C (min=17, max=106)
• Средняя температура дисков по больнице
29.3 °C (min=13, max=50)