Upgrade to Pro — share decks privately, control downloads, hide ads and more …
Sign up for free

SQLを実行したときに、PostgreSQLはどのようにデータにアクセスしているのか

Avatar for ISHIDA Akio ISHIDA Akio
July 07, 2018
Programming
300
0

 SQLを実行したときに、PostgreSQLはどのようにデータにアクセスしているのか

Avatar for ISHIDA Akio

ISHIDA Akio

July 07, 2018

More Decks by ISHIDA Akio

See All by ISHIDA Akio
Prophecyを使った ユニットテスト
Avatar for ISHIDA Akio iakio
0
15
phpspecで学ぶLondon School TDD
Avatar for ISHIDA Akio iakio
0
9
PostgreSQLの範囲型と排他制約
Avatar for ISHIDA Akio iakio
0
26
XIDを周回させてみよう
Avatar for ISHIDA Akio iakio
0
23
使いこなそうGUC
Avatar for ISHIDA Akio iakio
0
9

Other Decks in Programming

See All in Programming
ゲームコントローラやキーボードのファームウェアをSwiftで書く
Avatar for Kishikawa Katsumi kishikawakatsumi
1
250
手動確認はもう限界 〜XCUITestでCustom URL Schemeの遷移を起動種別ごとに自動テストする〜 / Testing Custom URL Schemes with XCUITest
Avatar for otouto otouto
0
330
20260914 AIエージェント時代のPlatform Engineering　LLM基盤とプロダクトの責務境界線
Avatar for Taiki Kanzaki kanfab1
7
2.2k
Are APIs Still Relevant in the AI Era?
Avatar for Antoine Bluchet soyuka
0
300
Ghostty + Neovimで作る 透明でカッコ良い開発環境
Avatar for Kanade Nonomura j341nono
0
120
JRuby: Past, Present, and Future
Avatar for headius headius
0
190
[Rails World 2026] Durable orchestration on Rails: from continuation to workflow
Avatar for Vladimir Dementyev palkan
0
180
難しいけど、読めた。- OSSの入口に立った話。
Avatar for shota sts11142
0
120
AI活用は、個人から組織へ｜マルチプレイヤーエージェントハーネス「QM」の社内活用事例 / AI use is moving from individuals to orgs
Avatar for r-kagaya rkaga
1
170
IBM Bob Dojo #1 仕様駆動開発入門
Avatar for Akira Onishi (IBM) oniak3ibm
PRO
0
180
巨大モノリシックアプリ モダン化大作戦
Avatar for Ryomm ktcryomm
1
1.1k
アクセシビリティから考える情報設計
Avatar for high-g high_g_engineer
0
390

Featured

See All Featured
Noah Learner - AI + Me: how we built a GSC Bulk Export data pipeline
Avatar for Tech SEO Connect techseoconnect
PRO
0
440
WCS-LA-2024
Avatar for Leonardo Collado-Torres lcolladotor
0
830
Fireside Chat
Avatar for paigeccino paigeccino
43
4k
How STYLIGHT went responsive
Avatar for nonsquared nonsquared
100
6.3k
Learning to Love Humans: Emotional Interface Design
Avatar for Aarron Walter aarron
275
41k
Documentation Writing (for coders)
Avatar for Carmen Chung carmenintech
77
5.5k
Darren the Foodie - Storyboard
Avatar for Kevinho.art khoart
PRO
4
3.9k
SEO for Brand Visibility & Recognition
Avatar for Aleyda Solis aleyda
0
4.7k
Data-driven link building: lessons from a $708K investment (BrightonSEO talk)
Avatar for Szymon Słowik szymonslowik
1
1.3k
エンジニアに許された特別な時間の終わり
Avatar for watany watany
109
250k
Connecting the Dots Between Site Speed, User Experience & Your Business [WebExpo 2025]
Avatar for Tammy Everts tammyeverts
11
1k
Designing Experiences People Love
Avatar for Jonathan Moore moore
143
24k

Transcript

  1. SQLを実⾏したときに、 PostgreSQLは どのようにデータに アクセスしているのか 2018.7.7 OSC2018 Hokkaido ISHIDA AKIO /

    @iakio

  2. 1000 Pages 10000 Cars 3 4 5 6 7 8

    9 10 11 12 13 14 15 16 17 18 1 2 100 Maker Model Color Used Car Magazine

  3. Maker Maker Model Price Model Page Pos HONDA FIT 345

    5 234 HONDA FIT 12 1 190 HONDA LIFE 567 6 160 TOYOTA AQUA 89 2 201 TOYOTA PRIUS 165 3 354 Key Location INDEX Price

  4. Maker = 'TOYOTA' AND Model = 'PRIUS' AND Price BETWEEN

    100 AND 200

  5. Maker = 'TOYOTA'

  6. Maker = 'TOYOTA'

  7. None
  8. None

  9. Root Leaf 「B+TreeVisualization」 https://www.cs.usfca.edu/~galles/visualization/BPlusTree.html

  10. UPDATE

  11. VACUUM

  12. UPDATE

  13. UPDATE fillfactor=50 「HOTの上⼿な使い⽅」 https://lets.postgresql.jp/documents/tutorial/hot3