Блиц-доклад на pgconf.russia 2018

Transcript

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