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
愛しのPostgreSQL ~ Herokuのデータベース & データ管理系サービスのおさら...
Search
Mitsuhiro Okamoto
June 25, 2018
Technology
0
160
愛しのPostgreSQL ~ Herokuのデータベース & データ管理系サービスのおさらいの話 〜
6月25日の Heroku meetup #21 “胸騒ぎのHeroku”の発表資料です。
Mitsuhiro Okamoto
June 25, 2018
Tweet
Share
More Decks by Mitsuhiro Okamoto
See All by Mitsuhiro Okamoto
Mulesoft Anypoint Platform ハンズオン
mokamoto
1
1.1k
Mulesoft Meetup Tokyo #2 Hands-on
mokamoto
1
350
DockerをHerokuでも
mokamoto
1
270
MuleSoftとAnypoint Platform
mokamoto
1
880
Other Decks in Technology
See All in Technology
_第3回__AIxIoTビジネス共創ラボ紹介資料_20250617.pdf
iotcomjpadmin
0
150
VCpp Link and Library - C++ breaktime 2025 Summer
harukasao
0
240
OpenHands🤲にContributeしてみた
kotauchisunsun
1
410
Observability infrastructure behind the trillion-messages scale Kafka platform
lycorptech_jp
PRO
0
130
プロダクトエンジニアリング組織への歩み、その現在地 / Our journey to becoming a product engineering organization
hiro_torii
0
120
Snowflake Summit 2025 データエンジニアリング関連新機能紹介 / Snowflake Summit 2025 What's New about Data Engineering
tiltmax3
0
300
Uniadex__公開版_20250617-AIxIoTビジネス共創ラボ_ツナガルチカラ_.pdf
iotcomjpadmin
0
160
VISITS_AIIoTビジネス共創ラボ登壇資料.pdf
iotcomjpadmin
0
160
【TiDB GAME DAY 2025】Shadowverse: Worlds Beyond にみる TiDB 活用術
cygames
0
1k
ハノーバーメッセ2025座談会.pdf
iotcomjpadmin
0
160
Абьюзим random_bytes(). Фёдор Кулаков, разработчик Lamoda Tech
lamodatech
0
330
ひとり情シスなCTOがLLMと始めるオペレーション最適化 / CTO's LLM-Powered Ops
yamitzky
0
420
Featured
See All Featured
For a Future-Friendly Web
brad_frost
179
9.8k
[RailsConf 2023] Rails as a piece of cake
palkan
55
5.6k
Connecting the Dots Between Site Speed, User Experience & Your Business [WebExpo 2025]
tammyeverts
5
210
Evolution of real-time – Irina Nazarova, EuRuKo, 2024
irinanazarova
8
790
Site-Speed That Sticks
csswizardry
10
660
Exploring the Power of Turbo Streams & Action Cable | RailsConf2023
kevinliebholz
33
5.9k
Building a Scalable Design System with Sketch
lauravandoore
462
33k
Java REST API Framework Comparison - PWX 2021
mraible
31
8.6k
I Don’t Have Time: Getting Over the Fear to Launch Your Podcast
jcasabona
32
2.3k
Refactoring Trust on Your Teams (GOTO; Chicago 2020)
rmw
34
3k
The Art of Delivering Value - GDevCon NA Keynote
reverentgeek
15
1.5k
Bootstrapping a Software Product
garrettdimon
PRO
307
110k
Transcript
)FSPLVNFFUVQ ˑ脼꾾ֺך)FSPLV˒ 䠥׃ך1PTUHSF42- _)FSPLVךر٦ةك٦أ ر٦ة盖椚禸؟٦ؽأךְֶׁך鑧 ։ .JUTVIJSP0LBNPUP !NJUTVIJSP
荈䊹稱➜ 䀤劤 ⯍峔 4BMFTGPSDFDPN 4FOJPS%FWFMPQFS&WBOHFMJTU 㸚⪒眔㔲 )FSPLV 4BMFTGPSDF涪禸 剑鵚.VMF4PGU
➙傈䪔ֲⰻ㺁 䠥׃ך1PTUHSF42- ؙ؎ؤ 5ءٍخفٖئٝز
)FSPLV1PTUHSFT 剑䧭擾׃1PTUHSF42-ךؙٓؐس ؟٦ؽأ
2)FSPLV%BUB؟٦ؽأ )FSPLV%BUBך63- سً؎ٝ כ
EBUBIFSPLVDPN
2)FSPLVדⵃ欽דֹر٦ة؟٦ؽأכ 珏겲֮תׅ
)FSPLVדⵃ欽דֹر٦ة؟٦ؽأ 珏겲ךر٦ة؟٦ؽأ )FSPLV1PTUHSFT )FSPLV3FEJT )FSPLV,BGLB
)FSPLV1PTUHSFTהכ • 秪磏זر٦ةك٦أ؟٦ؽأךؙٓؐس؟٦ؽأה ׃גכ⚅歲ⴱ • ♰馄ִؙٓأة盖椚 • ⚅歲ٖكٕך1PTUHSFTך㼔㹺ָ麊欽 • ؎ٝأةٝزفٗؽآّصؚٝծر؍كٗحػ٦ؒ
ؙألٔؒٝأծع؎أ؛٦ٕ • 垥彊ד剑倜ךؔ٦فٝا٦أر؍أزٔؽُ٦ءّ ٝ⢪欽 • ٗحؙ؎ٝ搀׃ Heroku Postgres
2)FSPLV1PTUHSFTل٦آ )FSPLV1PTUHSFT%#ل٦آד (6*ַⵃ欽דֹ堣腉כ
)FSPLV1PTUHSFT%C9 ˊ %BB4 1PTUHSFT״⤑ⵃח⢪ֲךخ٦ٕ♧筰ח䲿⣘ DbXʢ֦ுػೳʣ DB ӡ༻ PostgresίΞ ΫϥυΠϯϑϥ •
ؔ٦فٝا٦أ • ؔـآؙؑزꟼ⤘ر٦ ةك٦أ盖椚ءأذي • 42-垥彊 • 0SBDMFװ.442-הך 窟さ٥و؎ؚٖ٦ءّ ٝ • ػؿؓ٦وٝأⴓ匿 • ر٦ةؙٔحف • ؿؓ٦ؚؗٝ • ؎ٝة٦ؿؑأ (6* $-* • ٗ٦ٕغحؙ • ؿؓٗ،٦ • ؝ٝؿ؍ؚٖ٦ءّٝך 剑黝⻉ך湊鋔⡤ ⵖ • )JHIBWBJMBCJMJUZⱔꞿ 圓䧭 • 农〾⻉ • 5JFSח䘔ׄتؐٝة؎ ي罣䚍 • ػحث䔲ג • 荈⹛ٌصةؚٔٝ
- Health - I/O - Utilization %
# ' &! $ Index "'
- Health - I/O - Utilization
Metric Index
2#BDLVQTךؙ؎ؤ 1PTUHSFTדغحؙ،حف欽鷿ד %-דֹ%#ך؟؎ؤכ
#BDLVQT DL (20GB)
2'PMMPXFST FollowerFork
'PMMPXFST DB"*4)&( 243$ leader DB# % OLTPfollower& " Leader
.,0'1-2/4+! Fork = Follower#' '-*4+&!
21SFNJVN 1SJWBUFֶ״ן 4IJFME%BUBCBTFTぢֽ堣腉 Premium, Private Shield Databases
"VUPNBUJD)JHI"WBJMBCJMJUZ )" • 'PMMPXFS%#ך״ֲח)"欽ךأةٝغ؎ر٦ةك٦أⴽך "84 "WBJMBCJMJUZ;POFח⡲䧭 • ؿؑ؎ٕؔ٦غ٦ָ饯ֹג)FSPLV،فַٔכ鷲麓涸ח،ؙإ أ〳腉 •
%"5"#"4&@63- ֶ״ן )&30,6@1045(3&4@ @63- DPOGJHWBST ך⦼ָ ؿؑ؎ٕؔ٦غ٦儗ח荈⹛涸ח㢌刿ׁ 㢌侧せכ㢌׆ • ؿؑ؎ٕؔ٦غ٦勴⟝ֶ״ןؿؑ؎ٕؔ٦غ٦Ⳣ椚כ荈⹛涸ח遤 • 鑫稢ֶ״ן岣䠐挿כֿ • Premium, Private Shield Databases
23PMMCBDL Heroku Postgres
3PMMCBDL
2ךקַךش؎أז堣腉
ךקַךش؎أז堣腉 • 荈⹛قٕأثؑحؙח״㸣Ⰻ盖椚ךر٦ةك٦أ؟٦ؽأ • 荜ㄏ涸זꥺ㹱ָ涪欰׃㜥さךر٦ة嶊㣟剑㼭ꣲח䫇ִծ8SJUF BIFBEMPH 8"- 䱰欽 • 1(#BDLVQT
ח״暟椚ر٦ةك٦أغحؙ،حف ؔفءָّٝ搀俱 • %BUBDMJQT ח״إُؗ،זر٦ةֶ״ןؙؒٔךⰟ剣 • 44-ד⥂隊ׁ QTRMMJCQR ،ؙإأ • 何鸡搀׃ךؾُ،ז1PTUHSFTָ珩⫴ )FSPLV1PTUHSFT-FHBDZ 1MBOT ד麓ךغ٦آّٝⵃ欽〳腉 • 1PTUHSFT FYUFOTJPOT • זוזו
21PTUHSFT0QFO4PVSDFפך؝ٝزٔؽُ٦ءّٝ Heroku PostgreSQL
1PTUHSFT0QFO4PVSDFפך؝ٝزٔؽُ٦ءّٝ • 1BSBMMFMFYFDVUJPOPGTFRVFOUJBMTDBOT KPJOT BOEBHHSFHBUFT • "WPJETDBOOJOHQBHFTVOOFDFTTBSJMZEVSJOH WBDVVNGSFF[FPQFSBUJPOT • 4ZODISPOPVTSFQMJDBUJPOOPXBMMPXT
NVMUJQMFTUBOECZTFSWFSTGPSJODSFBTFE SFMJBCJMJUZ • 'VMMUFYUTFBSDIDBOOPXTFBSDIGPSQISBTFT NVMUJQMFBEKBDFOUXPSET • QPTUHSFT@GEX OPXTVQQPSUTSFNPUFKPJOT TPSUT 61%"5&T BOE%&-&5&T • 4VCTUBOUJBMQFSGPSNBODFJNQSPWFNFOUT FTQFDJBMMZJOUIFBSFBPGTDBMBCJMJUZPONVMUJ $16TPDLFUTFSWFST • %POUUISPXTFSJBMJ[BUJPOFSSPSTGPSTFMG DPOGMJDUJOHJOTFSUJPOTJO*/4&350/ $0/'-*$5 • 'JYVTFBGUFSGSFFIB[BSEJOFYFDVUJPOPG BHHSFHBUFGVODUJPOTVTJOH%*45*/$5BTUIJT DPVMEMFBEUPBDSBTIPSJODPSSFDURVFSZ SFTVMUT • "WPJEWFSZMPXQSPCBCJMJUZEBUBDPSSVQUJPO EVFUPUFTUJOHUVQMFWJTJCJMJUZXJUIPVU IPMEJOHCVGGFSMPDL #Z)FSPLV
21PTUHSFT⟃㢩ך鼅䫛肇 Postgres Add-on
.Z42-ך "EEPO֮תׅ
2㢩鿇ח%#Ⱅׅחכ Odata
)FSPLV$POOFDU • 1PTUHSFTךر٦ة0%BUBד 㢩鿇חⰕ〳腉 • 4BMFTGPSDFך%#ה倯ぢず劍ך 堣腉֮
➙傈ךתה )FSPLVךر٦ة؟٦ؽأ⤑ⵃדׅ״ Heroku Postgres Managed SQL Database as a Service
for all developers.
thank y u ָ֮הֲ׀ְׂת׃