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
27
XIDを周回させてみよう
Avatar for ISHIDA Akio iakio
0
23
使いこなそうGUC
Avatar for ISHIDA Akio iakio
0
9

Other Decks in Programming

See All in Programming
全ての永続トークンを、生まれる前に消し去りたい！
Avatar for sylph01 sylph01
2
960
[Dev Group Paris Octobre 26] Agentforce, SIforce, Claudeforce, Slackbot… on s'y retrouve ?
Avatar for Nathan Abondance nabondance
0
110
Agents on Rails - Rails at Scale 2026
Avatar for Irina Nazarova irinanazarova
0
560
SalesForceを内製化！？ ~ HR事業を支える顧客管理基盤のインフラを大公開 ~
Avatar for Kobujee_53 oku053
0
180
自サークルのIdPからログアウトできるようになるまで
Avatar for taiseiue taiseiue
1
140
最近”作らせてる” ローカルAIアプリの話
Avatar for ITO Akihiro akit37
0
470
Herb in Rails 8.2: Your ERB views, now HTML-aware @ Kaigi on Rails 2026, Tokyo, Japan
Avatar for Marco Roth marcoroth
2
240
設計次第でAIコードの読む量は減らせる / designing-for-code-reading
Avatar for MinoDriven minodriven
35
17k
HTML-in-Canvasで作る未来のWeb UI表現
Avatar for IKEDA Yasunobu clockmaker
5
5.1k
Domain-Driven Transformation
Avatar for Henning Schwentner hschwentner
2
2.3k
現場と育てるRailsモデリング 〜Spreadsheetから始めたモデル設計〜
Avatar for siroemk siroemk
2
610
Railsのためのパスキー実践入門 〜マルチテナントSaaSでの意思決定〜
Avatar for utakaha utakaha
2
650

Featured

See All Featured
The Invisible Side of Design
Avatar for Vitaly Friedman smashingmag
301
52k
SEO in 2025: How to Prepare for the Future of Search
Avatar for Michael King ipullrank
3
3.9k
Believing is Seeing
Avatar for Spiro Bolos oripsolob
1
240
A Tale of Four Properties
Avatar for Chris Coyier chriscoyier
163
24k
The Mindset for Success: Future Career Progression
Avatar for Greg Gifford greggifford
PRO
0
540
Making the Leap to Tech Lead
Avatar for Ryan Cromwell cromwellryan
135
10k
Put a Button on it: Removing Barriers to Going Fast.
Avatar for kastner kastner
60
4.6k
Into the Great Unknown - MozCon
Avatar for Noah Learner thekraken
41
2.8k
The World Runs on Bad Software
Avatar for Brandon Keepers bkeepers
PRO
72
12k
Neural Spatial Audio Processing for Sound Field Analysis and Control
Avatar for NII S. Koyama's Lab skoyamalab
0
570
A Modern Web Designer's Workflow
Avatar for Chris Coyier chriscoyier
699
190k
The untapped power of vector embeddings
Avatar for Frank van Dijk frankvandijk
2
1.9k

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