Upgrade to Pro — share decks privately, control downloads, hide ads and more …

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

Sponsored · Your Podcast. Everywhere. Effortlessly. Share. Educate. Inspire. Entertain. You do you. We'll handle the rest. →
Avatar for ISHIDA Akio ISHIDA Akio
July 07, 2018
Programming
0
280

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

Avatar for ISHIDA Akio

ISHIDA Akio

July 07, 2018
Tweet

More Decks by ISHIDA Akio

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

Other Decks in Programming

See All in Programming
今こそ知るべき耐量子計算機暗号(PQC)入門 / PQC: What You Need to Know Now
Avatar for mackey0225 mackey0225
3
380
izumin5210のプロポーザルのネタ探し #tskaigi_msup
Avatar for izumin5210 izumin5210
1
140
AgentCoreとHuman in the Loop
Avatar for Har1101 har1101
5
240
コマンドとリード間の連携に対する脅威分析フレームワーク
Avatar for Aja9tochin pandayumi
1
460
生成AIを活用したソフトウェア開発ライフサイクル変革の現在値
Avatar for Hiroyuki Mori hiroyukimori
PRO
0
100
CSC307 Lecture 05
Avatar for Javier Gonzalez-Sanchez javiergs
PRO
0
500
AIフル活用時代だからこそ学んでおきたい働き方の心得
Avatar for shinoyu shinoyu
0
140
Lambda のコードストレージ容量に気をつけましょう
Avatar for tatsuki-yamada tattwan718
0
140
開発者から情シスまで - 多様なユーザー層に届けるAPI提供戦略 / Postman API Night Okinawa 2026 Winter
Avatar for tasshi tasshi
0
210
例外処理とどう使い分ける？Result型を使ったエラー設計 #burikaigi
Avatar for Takuma Kajikawa kajitack
16
6.1k
Amazon Bedrockを活用したRAGの品質管理パイプライン構築
Avatar for とすり tosuri13
5
780
LLM Observabilityによる 対話型音声AIアプリケーションの安定運用
Avatar for Hiroyuki Moriya gekko0114
2
430

Featured

See All Featured
SEO Brein meetup: CTRL+C is not how to scale international SEO
Avatar for Linda Hogenes lindahogenes
0
2.3k
Reflections from 52 weeks, 52 projects
Avatar for Jefferson Lam jeffersonlam
356
21k
Game over? The fight for quality and originality in the time of robots
Avatar for Wayne Barker wayneb77
1
120
How to Align SEO within the Product Triangle To Get 
Buy-In & Support - #RIMC
Avatar for Aleyda Solis aleyda
1
1.4k
Building Better People: How to give real-time feedback that sticks.
Avatar for Will Jessup wjessup
370
20k
Docker and Python
Avatar for Tania Allard trallard
47
3.7k
Imperfection Machines: The Place of Print at Facebook
Avatar for Scott Boms scottboms
269
14k
Marketing Yourself as an Engineer | Alaka | Gurzu
Avatar for Gurzu gurzu
0
130
JavaScript: Past, Present, and Future - NDC Porto 2020
Avatar for David Neal reverentgeek
52
5.8k
DevOps and Value Stream Thinking: Enabling flow, efficiency and business value
Avatar for Helen Beal helenjbeal
1
100
Thoughts on Productivity
Avatar for Jon Yablonski jonyablonski
74
5k
The untapped power of vector embeddings
Avatar for Frank van Dijk frankvandijk
1
1.6k

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