Lock in $30 Savings on PRO—Offer Ends Soon! ⏳

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

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

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

Avatar for ISHIDA Akio

ISHIDA Akio

July 07, 2018
Tweet

Other Decks in Programming

See All in Programming
Findy AI+の開発、運用におけるMCP活用事例
Avatar for starfish719 starfish719
0
1.7k
Context is King？ 〜Verifiability時代とコンテキスト設計 / Beyond "Context is King"
Avatar for r-kagaya rkaga
10
1.4k
C-Shared Buildで突破するAI Agent バックテストの壁
Avatar for po3rin po3rin
0
420
Deno Tunnel を使ってみた話
Avatar for すずとも kamekyame
0
240
JETLS.jl ─ A New Language Server for Julia
Avatar for abap34 abap34
2
450
脳の「省エネモード」をデバッグする ～System 1（直感）と System 2（論理）の切り替え～
Avatar for HideyukiKitao panda728
PRO
0
120
愛される翻訳の秘訣
Avatar for Kishikawa Katsumi kishikawakatsumi
3
350
大規模Cloud Native環境におけるFalcoの運用
Avatar for Chihiro Hasegawa owlinux1000
0
190
著者と進める！『AIと個人開発したくなったらまずCursorで要件定義だ！』
Avatar for yasuna yasunacoffee
0
160
Rubyで鍛える仕組み化プロヂュース力
Avatar for muryoimpl muryoimpl
0
160
AI Agent Dojo ＃4: watsonx Orchestrate ADK体験
Avatar for Akira Onishi (IBM) oniak3ibm
PRO
0
110
リリース時」テストから「デイリー実行」へ！開発マネージャが取り組んだ、レガシー自動テストのモダン化戦略
Avatar for goataka (GOAMI Takaaki) goataka
0
140

Featured

See All Featured
How GitHub (no longer) Works
Avatar for Zach Holman holman
316
140k
Fantastic passwords and where to find them - at NoRuKo
Avatar for Phil Nash philnash
52
3.5k
What's in a price? How to price your products and services
Avatar for Michael Herold michaelherold
246
13k
Winning Ecommerce Organic Search in an AI Era - #searchnstuff2025
Avatar for Aleyda Solis aleyda
0
1.8k
Organizational Design Perspectives: An Ontology of Organizational Design Elements
Avatar for Dr. Kim W Petersen kimpetersen
PRO
0
45
Bioeconomy Workshop: Dr. Julius Ecuru, Opportunities for a Bioeconomy in West Africa
Avatar for AKADEMIYA2063 akademiya2063
PRO
0
31
JAMstack: Web Apps at Ludicrous Speed - All Things Open 2022
Avatar for David Neal reverentgeek
1
290
The Art of Delivering Value - GDevCon NA Keynote
Avatar for David Neal reverentgeek
16
1.8k
Noah Learner - AI + Me: how we built a GSC Bulk Export data pipeline
Avatar for Tech SEO Connect techseoconnect
PRO
0
74
How to Ace a Technical Interview
Avatar for Jacob Kaplan-Moss jacobian
281
24k
SEO for Brand Visibility & Recognition
Avatar for Aleyda Solis aleyda
0
4.1k
Future Trends and Review - Lecture 12 - Web Technologies (1019888BNR)
Avatar for Beat Signer signer
PRO
0
3.1k

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