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
290
Автодискавери в мониторинге
def
0
72
Эксплуатация container based инфраструктур
def
1
320
Other Decks in Technology
See All in Technology
いつか使うかも貯金してたらめちゃめちゃ機能が増えてた話
riyaamemiya
0
610
LayerXにおけるLLMプロダクト開発の今までとこれから
layerx
PRO
3
600
Cypress or Playwright?
rainerhahnekamp
0
170
20分で完全に理解するGrafanaダッシュボード
hamadakoji
5
890
AOAI をきっかけに 社内の Azure 管理を見直した話
recruitengineers
PRO
1
450
Grafana x PagerDuty Better Together
jacopen
1
250
Babylon.js JAPAN活動紹介 (2024/4)
limes2018
1
110
Google Cloud Next '24でブログを10本書いた方法と勉強会を沸かせた方法
yasumuusan
0
330
LLM開発・活用の舞台裏@2024.04.25
yushin_n
3
1.1k
自己改善からチームを動かす! 「セルフエンジニアリングマネージャー」のすゝめ
shoota
6
1k
EM完全に理解した と思ったけど、 やっぱり何も分からなかった話 / EM Night Fukuoka #1
hirutas
0
280
Oracle Base Database Service 技術詳細
oracle4engineer
PRO
4
37k
Featured
See All Featured
Java REST API Framework Comparison - PWX 2021
mraible
PRO
19
6.9k
Building Adaptive Systems
keathley
32
1.9k
Making the Leap to Tech Lead
cromwellryan
125
8.5k
個人開発の失敗を避けるイケてる考え方 / tips for indie hackers
panda_program
65
14k
The Invisible Side of Design
smashingmag
294
49k
How to name files
jennybc
65
93k
Refactoring Trust on Your Teams (GOTO; Chicago 2020)
rmw
26
2.3k
BBQ
matthewcrist
80
8.8k
"I'm Feeling Lucky" - Building Great Search Experiences for Today's Users (#IAC19)
danielanewman
222
21k
Teambox: Starting and Learning
jrom
128
8.4k
KATA
mclloyd
16
12k
What’s in a name? Adding method to the madness
productmarketing
PRO
17
2.7k
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)