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
80
Эксплуатация container based инфраструктур
def
1
320
Other Decks in Technology
See All in Technology
知られざるprops命名の慣習 アクション編
uhyo
10
2.4k
第4回 関東Kaggler会 [Training LLMs with Limited VRAM]
tascj
12
1.7k
EKS Pod Identity における推移的な session tags
z63d
1
200
ドキュメントはAIの味方!スタートアップのアジャイルを加速するADR
kawauso
3
350
あなたの知らない OneDrive
murachiakira
0
240
自社製CMSからmicroCMSへのリプレースがプロダクトグロースを加速させた話
nextbeatdev
0
130
Backboneとしてのtimm2025
yu4u
4
1.5k
実践データベース設計 ①データベース設計概論
recruitengineers
PRO
2
210
キャリアを支え組織力を高める「多層型ふりかえり」 / 20250821 Kazuki Mori
shift_evolve
PRO
2
300
Postman MCP 関連機能アップデート / Postman MCP feature updates
yokawasa
0
150
人を動かすことについて考える
ichimichi
2
320
イオン店舗一覧ページのパフォーマンスチューニング事例 / Performance tuning example for AEON store list page
aeonpeople
2
280
Featured
See All Featured
RailsConf & Balkan Ruby 2019: The Past, Present, and Future of Rails at GitHub
eileencodes
139
34k
Bash Introduction
62gerente
614
210k
Automating Front-end Workflow
addyosmani
1370
200k
Fight the Zombie Pattern Library - RWD Summit 2016
marcelosomers
234
17k
Bootstrapping a Software Product
garrettdimon
PRO
307
110k
A Tale of Four Properties
chriscoyier
160
23k
Easily Structure & Communicate Ideas using Wireframe
afnizarnur
194
16k
Navigating Team Friction
lara
189
15k
Building a Scalable Design System with Sketch
lauravandoore
462
33k
I Don’t Have Time: Getting Over the Fear to Launch Your Podcast
jcasabona
33
2.4k
Product Roadmaps are Hard
iamctodd
PRO
54
11k
The Language of Interfaces
destraynor
160
25k
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)