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
410
Блиц-доклад на pgconf.russia 2018
Nikolay Sivko
February 07, 2018
Tweet
Share
More Decks by Nikolay Sivko
See All by Nikolay Sivko
Тонкая настройка балансировки нагрузки
def
2
340
Автодискавери в мониторинге
def
0
74
Эксплуатация container based инфраструктур
def
1
320
Other Decks in Technology
See All in Technology
LINEヤフーのフロントエンド組織・体制の紹介
lycorp_recruit_jp
1
1.2k
可視化により内部品質をあげるAIドキュメントリバース/20240910 Hiromitsu Akiba
shift_evolve
0
230
DevRelの始め方
moongift
PRO
2
400
不動産tech Product Night#2_AIことはじめ_GA橋本
takehikohashimoto
0
190
サプライチェーン攻撃に備える
ryunen344
0
390
プログラム検証入門
riru
6
880
20240911_New_Relicダッシュボード活用例
speakerdeckfk
0
110
JEP 480: Structured Concurrency
aya_ebata
0
130
スタッフエンジニアの道: The Staff Engineer’s Path
snoozer05
PRO
44
14k
『GRANBLUE FANTASY: Relink』クオリティと物量の両立に挑戦したフェイシャルアニメーション事例 ~カットシーンからランタイムまで~
cygames
0
120
AI前提のサービス運用ってなんだろう?
ryuichi1208
3
1.1k
フルカイテン株式会社 採用資料
fullkaiten
0
32k
Featured
See All Featured
What’s in a name? Adding method to the madness
productmarketing
PRO
21
3k
Save Time (by Creating Custom Rails Generators)
garrettdimon
PRO
24
610
Sharpening the Axe: The Primacy of Toolmaking
bcantrill
36
1.7k
Web Components: a chance to create the future
zenorocha
309
42k
Building Flexible Design Systems
yeseniaperezcruz
325
38k
Atom: Resistance is Futile
akmur
261
25k
Evolution of real-time – Irina Nazarova, EuRuKo, 2024
irinanazarova
0
130
Clear Off the Table
cherdarchuk
91
320k
Embracing the Ebb and Flow
colly
83
4.4k
Exploring the Power of Turbo Streams & Action Cable | RailsConf2023
kevinliebholz
26
3.9k
The Language of Interfaces
destraynor
153
23k
Being A Developer After 40
akosma
84
590k
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)