Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
Блиц-доклад на pgconf.russia 2018
Search
Nikolay Sivko
February 07, 2018
Technology
1
420
Блиц-доклад на pgconf.russia 2018
Nikolay Sivko
February 07, 2018
Tweet
Share
More Decks by Nikolay Sivko
See All by Nikolay Sivko
Тонкая настройка балансировки нагрузки
def
2
380
Автодискавери в мониторинге
def
0
82
Эксплуатация container based инфраструктур
def
1
320
Other Decks in Technology
See All in Technology
OPENLOGI Company Profile for engineer
hr01
1
46k
What's new in OpenShift 4.20
redhatlivestreaming
0
340
【SORACOM UG Explorer 2025】さらなる10年へ ~ SORACOM MVC 発表
soracom
PRO
0
170
ハノーファーメッセ2025で見た生成AI活用ユースケース.pdf
hamadakoji
1
500
webpack依存からの脱却!快適フロントエンド開発をViteで実現する #vuefes
bengo4com
4
3.6k
re:Inventに行くまでにやっておきたいこと
nagisa53
0
690
様々なファイルシステム
sat
PRO
0
260
オブザーバビリティが育むシステム理解と好奇心
maruloop
3
1.5k
AWSが好きすぎて、41歳でエンジニアになり、AAIを経由してAWSパートナー企業に入った話
yama3133
1
170
Retrospectiveを振り返ろう
nakasho
0
130
Observability — Extending Into Incident Response
nari_ex
1
570
GPUをつかってベクトル検索を扱う手法のお話し~NVIDIA cuVSとCAGRA~
fshuhe
0
170
Featured
See All Featured
Creating an realtime collaboration tool: Agile Flush - .NET Oxford
marcduiker
34
2.3k
Become a Pro
speakerdeck
PRO
29
5.6k
Scaling GitHub
holman
463
140k
YesSQL, Process and Tooling at Scale
rocio
173
15k
Stop Working from a Prison Cell
hatefulcrawdad
272
21k
It's Worth the Effort
3n
187
28k
A Tale of Four Properties
chriscoyier
161
23k
Keith and Marios Guide to Fast Websites
keithpitt
411
23k
jQuery: Nuts, Bolts and Bling
dougneiner
65
7.9k
Designing for Performance
lara
610
69k
Gamification - CAS2011
davidbonilla
81
5.5k
StorybookのUI Testing Handbookを読んだ
zakiyama
31
6.2k
Transcript
Интересные факты о 500+ инстансов PG наших клиентов
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
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
DB size • Sum = 245 Tb • Avg =
457 Gb • Max = 8.5 Tb • Avg (total_phys_mem:db_size) = 1 : 7
Transactions • Sum = 240 000 TPS • Commits :
rollbacks = 500 : 1
WAL • Sum WAL rate= 250 MB/s (2Gbit/s) • Max
WAL rate = 20MB/s (160Mbit/s)
max_connections • Avg max_conns = 360 • Max max_conns =
3000 • Avg actual connections = 10% (max)
Memory • Avg shared_buffers_size : total_mem = 1 : 3
• Avg buffer cache hit rate = 98 % • Avg os_page_cache : total_mem = 1 : 2
work_mem • Max = 4G • (work_mem * max_conns):total_mem =
1.5:1
Disk • Avg disk usage = 50% • IOPS read
: write = 1.8 : 1 • IO traffic read : write = 3 : 1
PG + SSD • SSD стоит в ~20% серверов* •
SSD wearout indicator (S.M.A.R.T): – Avg = 96.5% – Min = 55%
Самое главное :) • Средняя температура CPU по больнице 43.8
°C (min=17, max=106) • Средняя температура дисков по больнице 29.3 °C (min=13, max=50)