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

Faster Queries = More Animal Crossing

Jonan Scheffler
March 31, 2020
Programming
0
93

Faster Queries = More Animal Crossing

A quick walkthrough of common query inefficiencies using PostgreSQL and TimescaleDB.

Jonan Scheffler

March 31, 2020
Tweet

More Decks by Jonan Scheffler

See All by Jonan Scheffler
Sleeping in Airports: The Magical, Terrible Life of a Developer Advocate
thejonanshow
0
11
inventing_friends.pdf
thejonanshow
0
18
Inventing Friends: Actioncable + AVS = <3
thejonanshow
0
80
Building HAL: Running Ruby with your Voice
thejonanshow
1
55
Deploying MEAN on Heroku
thejonanshow
2
37
Robolove
thejonanshow
0
34
Hacking Cognition
thejonanshow
2
110

Other Decks in Programming

See All in Programming
実録レガシー Rails アプリ改善ジャーニー / Legacy Rails app improvement journey
shutooike
2
110
WantedlyでのCompose導入 / Introducing Jetpack Compose at Wantedly
kubode
1
110
Learning PHP with PHP Parser
inouehi
0
160
Dart3を試す
masumitsu
0
170
失敗から学ぶオーナーシップ欠乏症への処方箋 #phperkaigi #d
77web
0
140
結合テストの自動化にQAはどうかかわっていったか
nagworld
0
130
Android端末のNFCを無効化しようとしてダメだった話
mitchan
1
2.8k
PHPで任意精度演算を行って「正しい」金額計算をする方法 / Perform arbitrary precision arithmetic in PHP to achieve "accurate" monetary calculations
hiro_y
1
220
Lightweight Architectures With Angular's Latest Innovations
manfredsteyer
PRO
0
290
改めて整理するWebアプリのビルド・デプロイの基本
os1ma
4
570
いろいろなフレームワークの仕組みを index.php から読み解こう / index.php of each framework
okashoi
0
240
Famm Android改善記
akatsuki174
0
120

Featured

See All Featured
Art, The Web, and Tiny UX
lynnandtonic
284
18k
Writing Fast Ruby
sferik
613
58k
10 Git Anti Patterns You Should be Aware of
lemiorhan
643
55k
Six Lessons from altMBA
skipperchong
15
2.4k
GraphQLの誤解/rethinking-graphql
sonatard
39
8k
Bootstrapping a Software Product
garrettdimon
299
110k
JavaScript: Past, Present, and Future - NDC Porto 2020
reverentgeek
38
3.7k
Scaling GitHub
holman
453
140k
A Tale of Four Properties
chriscoyier
149
21k
Reflections from 52 weeks, 52 projects
jeffersonlam
339
18k
Automating Front-end Workflow
addyosmani
1351
200k
Documentation Writing (for coders)
carmenintech
51
3k

Transcript

  1. FASTER QUERIES
    = MORE ANIMAL CROSSING

    View Slide

  2. @thejonanshow

    View Slide

  3. @thejonanshow

    View Slide

  4. @thejonanshow

    View Slide

  5. @thejonanshow

    View Slide

  6. @thejonanshow

    View Slide

  7. @thejonanshow

    View Slide

  8. @thejonanshow

    View Slide

  9. @thejonanshow

    View Slide

  10. @thejonanshow

    View Slide

  11. @thejonanshow

    View Slide

  12. @thejonanshow

    View Slide

  13. @thejonanshow

    View Slide

  14. @thejonanshow

    View Slide

  15. @thejonanshow

    View Slide

  16. @thejonanshow

    View Slide

  17. @thejonanshow

    View Slide

  18. @thejonanshow

    View Slide

  19. @thejonanshow

    View Slide

  20. @thejonanshow

    View Slide

  21. @thejonanshow

    View Slide

  22. @thejonanshow

    View Slide

  23. @thejonanshow

    View Slide

  24. @thejonanshow

    View Slide

  25. @thejonanshow

    View Slide

  26. @thejonanshow

    View Slide

  27. @thejonanshow

    View Slide

  28. @thejonanshow

    View Slide

  29. @thejonanshow

    View Slide

  30. @thejonanshow

    View Slide

  31. @thejonanshow

    View Slide

  32. @thejonanshow

    View Slide

  33. @thejonanshow

    View Slide

  34. @thejonanshow
    - Common Table Expressions slow down small queries

    View Slide

  35. @thejonanshow
    - Common Table Expressions slow down small queries
    - LIKE and ILIKE dodge indexes, use pg_trgm

    View Slide

  36. @thejonanshow
    - Common Table Expressions slow down small queries
    - LIKE and ILIKE dodge indexes, use pg_trgm
    - Types matter, avoid letting the planner cast values for you

    View Slide

  37. @thejonanshow
    Thank You!
    ❤
    github.com/timescale/wikistream-docker

    View Slide