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
370
Автодискавери в мониторинге
def
0
78
Эксплуатация container based инфраструктур
def
1
320
Other Decks in Technology
See All in Technology
AI エンジニアの立場からみた、AI コーディング時代の開発の品質向上の取り組みと妄想
soh9834
8
620
経理出身PdMがAIプロダクト開発を_ハンズオンで学んだ話.pdf
shunsukenarita
1
260
Rubyの国のPerlMonger
anatofuz
1
370
大規模イベントを支える ABEMA の アーキテクチャ 変遷 2025
nagapad
5
580
VLMサービスを用いた請求書データ化検証 / SaaSxML_Session_1
sansan_randd
0
150
隙間時間で爆速開発! Claude Code × Vibe Coding で作るマニュアル自動生成サービス
akitomonam
2
240
P2P ではじめる WebRTC のつまづきどころ
tnoho
1
280
ファインディにおける Dataform ブランチ戦略
hiracky16
0
240
AI時代の知識創造 ─GeminiとSECIモデルで読み解く “暗黙知”と創造の境界線
nyagasan
0
170
Gemini in Android Studio - Google I/O Bangkok '25
akexorcist
0
110
【Λ(らむだ)】最近のアプデ情報 / RPALT20250729
lambda
0
190
Vision Language Modelと自動運転AIの最前線_20250730
yuyamaguchi
2
900
Featured
See All Featured
Art, The Web, and Tiny UX
lynnandtonic
301
21k
The Success of Rails: Ensuring Growth for the Next 100 Years
eileencodes
45
7.5k
Git: the NoSQL Database
bkeepers
PRO
431
65k
Sharpening the Axe: The Primacy of Toolmaking
bcantrill
44
2.4k
Testing 201, or: Great Expectations
jmmastey
44
7.6k
ReactJS: Keep Simple. Everything can be a component!
pedronauck
667
120k
Helping Users Find Their Own Way: Creating Modern Search Experiences
danielanewman
29
2.8k
StorybookのUI Testing Handbookを読んだ
zakiyama
30
5.9k
Product Roadmaps are Hard
iamctodd
PRO
54
11k
Being A Developer After 40
akosma
90
590k
YesSQL, Process and Tooling at Scale
rocio
173
14k
Site-Speed That Sticks
csswizardry
10
730
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)