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

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

Sponsored · Ship Features Fearlessly Turn features on and off without deploys. Used by thousands of Ruby developers. →
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
CSC307 Lecture 03
Avatar for Javier Gonzalez-Sanchez javiergs
PRO
1
490
CSC307 Lecture 01
Avatar for Javier Gonzalez-Sanchez javiergs
PRO
0
690
なるべく楽してバックエンドに型をつけたい！(楽とは言ってない)
Avatar for HIBIKI CUBE hibiki_cube
0
140
Package Management Learnings from Homebrew
Avatar for Mike McQuaid mikemcquaid
0
230
MDN Web Docs に日本語翻訳でコントリビュート
Avatar for uutan1108 ohmori_yusuke
0
650
HTTPプロトコル正しく理解していますか？ 〜かわいい猫と共に学ぼう。ฅ^•ω•^ฅ ﾆｬ〜
Avatar for ♛Heitor Hirose hekuchan
2
690
AtCoder Conference 2025
Avatar for shindannin shindannin
0
1.1k
余白を設計しフロントエンド開発を 加速させる
Avatar for karacoro / からころ tsukuha
7
2.1k
インターン生でもAuth0で 認証基盤刷新が出来るのか
Avatar for takumi taku271
0
190
Smart Handoff/Pickup ガイド - Claude Code セッション管理
Avatar for rasshii yukiigarashi
0
140
OCaml 5でモダンな並列プログラミングを Enjoyしよう!
Avatar for Haochen Kotoi-Xie haochenx
0
140
20260127_試行錯誤の結晶を1冊に。著者が解説 先輩データサイエンティストからの指南書 / author's_commentary_ds_instructions_guide
Avatar for nash_efp nash_efp
1
980

Featured

See All Featured
The Art of Programming - Codeland 2020
Avatar for Erika Heidi erikaheidi
57
14k
Measuring Dark Social's Impact On Conversion and Attribution
Avatar for Stephen Akadiri stephenakadiri
1
130
Navigating Algorithm Shifts & AI Overviews - #SMXNext
Avatar for Aleyda Solis aleyda
0
1.1k
How To Stay Up To Date on Web Technology
Avatar for Chris Coyier chriscoyier
791
250k
What’s in a name? Adding method to the madness
Avatar for The Alliance productmarketing
PRO
24
3.9k
Faster Mobile Websites
Avatar for Dean Hume deanohume
310
31k
Become a Pro
Avatar for Speaker Deck speakerdeck
PRO
31
5.8k
Improving Core Web Vitals using Speculation Rules API
Avatar for Sergey Chernyshev sergeychernyshev
21
1.4k
Groundhog Day: Seeking Process in Gaming for Health
Avatar for Sebastian Deterding codingconduct
0
94
Evolving SEO for Evolving Search Engines
Avatar for Ryan Jones ryanjones
0
130
Side Projects
Avatar for Sacha Greif sachag
455
43k
Hiding What from Whom? A Critical Review of the History of Programming languages for Music
Avatar for Tomoya Matsuura tomoyanonymous
2
420

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