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
pprof vs runtime/trace (FlightRecorder)
task4233
0
170
組織観点からIAM Identity CenterとIAMの設計を考える
nrinetcom
PRO
1
190
Findy Team+のSOC2取得までの道のり
rvirus0817
0
370
Access-what? why and how, A11Y for All - Nordic.js 2025
gdomiciano
1
120
20250929_QaaS_vol20
mura_shin
0
130
「Verify with Wallet API」を アプリに導入するために
hinakko
1
250
AWS 잘하는 개발자 되기 - AWS 시작하기: 클라우드 개념부터 IAM까지
kimjaewook
0
110
いまさら聞けない ABテスト入門
skmr2348
1
210
『OCI で学ぶクラウドネイティブ 実践 × 理論ガイド』 書籍概要
oracle4engineer
PRO
2
120
BtoBプロダクト開発の深層
16bitidol
0
370
SREとソフトウェア開発者の合同チームはどのようにS3のコストを削減したか?
muziyoshiz
1
100
Escaping_the_Kraken_-_October_2025.pdf
mdalmijn
0
150
Featured
See All Featured
Build your cross-platform service in a week with App Engine
jlugia
232
18k
Faster Mobile Websites
deanohume
310
31k
How to Ace a Technical Interview
jacobian
280
24k
Balancing Empowerment & Direction
lara
4
680
Visualization
eitanlees
148
16k
Designing Dashboards & Data Visualisations in Web Apps
destraynor
231
53k
Music & Morning Musume
bryan
46
6.8k
The World Runs on Bad Software
bkeepers
PRO
71
11k
Save Time (by Creating Custom Rails Generators)
garrettdimon
PRO
32
1.6k
個人開発の失敗を避けるイケてる考え方 / tips for indie hackers
panda_program
114
20k
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
eileencodes
36
2.5k
Six Lessons from altMBA
skipperchong
28
4k
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)