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

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

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

 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
9
phpspecで学ぶLondon School TDD
Avatar for ISHIDA Akio iakio
0
4
PostgreSQLの範囲型と排他制約
Avatar for ISHIDA Akio iakio
0
10
XIDを周回させてみよう
Avatar for ISHIDA Akio iakio
0
10
使いこなそうGUC
Avatar for ISHIDA Akio iakio
0
6

Other Decks in Programming

See All in Programming
Migration to Signals, Signal Forms, Resource API, and NgRx Signal Store @Angular Days 03/2026 Munich
Avatar for Manfred Steyer manfredsteyer
PRO
0
150
Agentic AI: Evolution oder Revolution
Avatar for Lars Roewekamp mobilelarson
PRO
0
190
条件判定に名前、つけてますか？ #phperkaigi #c
Avatar for Hiromi Hishida 77web
2
810
Nuxt Server Components
Avatar for wattanx wattanx
0
130
メッセージングを利用して時間的結合を分離しよう #phperkaigi
Avatar for Takuma Kajikawa kajitack
3
330
How to stabilize UI tests using XCTest
Avatar for Akio Itaya akkeylab
0
140
Understanding Apache Lucene - More than just full-text search
Avatar for Alexander Reelsen spinscale
0
140
モックわからないマン卒業記 ~振る舞いを起点に見直した、フロントエンドテストにおけるモックの使いどころ~
Avatar for Tasuku Watanabe tasukuwatanabe
3
420
実践ハーネスエンジニアリング #MOSHTech
Avatar for Takuma Kajikawa kajitack
7
3.8k
Geminiをパートナーに神社DXシステムを個人開発した話（いなめぐDX 開発振り返り）
Avatar for T. Fujiba fujiba
0
100
S3ストレージクラスの「見える」「ある」「使える」は全部違う ─ 体験から見た、仕様の深淵を覗く
Avatar for ya_ma23 ya_ma23
0
1.1k
コードレビューをしない選択 #でぃーぷらすトウキョウ
Avatar for Takuma Kajikawa kajitack
3
1.1k

Featured

See All Featured
Optimizing for Happiness
Avatar for Tom Preston-Werner mojombo
378
71k
Bridging the Design Gap: How Collaborative Modelling removes blockers to flow between stakeholders and teams @FastFlow conf
Avatar for Kenny Baas-Schwegler baasie
0
490
Rebuilding a faster, lazier Slack
Avatar for samanthasiow samanthasiow
85
9.4k
Building a Scalable Design System with Sketch
Avatar for Laura Van Doore lauravandoore
463
34k
svc-hook: hooking system calls on ARM64 by binary rewriting
Avatar for Akira Moroo retrage
2
180
Build The Right Thing And Hit Your Dates
Avatar for Maggie C. maggiecrowley
39
3.1k
The agentic SEO stack - context over prompts
Avatar for schlessera schlessera
0
710
Lightning Talk: Beautiful Slides for Beginners
Avatar for Ines Montani inesmontani
PRO
1
490
Java REST API Framework Comparison - PWX 2021
Avatar for Matt Raible mraible
34
9.2k
Between Models and Reality
Avatar for mayunak mayunak
2
240
Hiding What from Whom? A Critical Review of the History of Programming languages for Music
Avatar for Tomoya Matsuura tomoyanonymous
2
590
Applied NLP in the Age of Generative AI
Avatar for Ines Montani inesmontani
PRO
4
2.2k

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