$30 off During Our Annual Pro Sale. View Details »

Faster Queries = More Animal Crossing

Jonan Scheffler
March 31, 2020
Programming
0
110

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
16
inventing_friends.pdf
thejonanshow
0
21
Inventing Friends: Actioncable + AVS = <3
thejonanshow
0
83
Building HAL: Running Ruby with your Voice
thejonanshow
1
66
Deploying MEAN on Heroku
thejonanshow
2
39
Robolove
thejonanshow
0
51
Hacking Cognition
thejonanshow
2
110

Other Decks in Programming

See All in Programming
Postman CLI で Integration Test
codemountains
1
300
Intro to Stateful Services or How to get 1 million RPS from a single node
antyadev
0
140
Gatlingによる負荷テスト入門
irof
6
560
アクセシビリティを理解するとフロントエンドのテストが楽になる！
nano72mkn
1
1.9k
ゆめみの Flutter エンジニア育成方法
morikann
0
250
リーンスタートアップのリーンな品質の話
techouse
0
490
個人開発がおすすめな理由
texmeijin
2
620
Foreign Function & Memory API ( FFM API )を用いたNativeライブラリ呼び出しと既存ライブラリの比較 ( JJUG CCC 2023 Fall )
hiroisojp
1
370
壓力測試大冒險：解鎖應用程式的隱藏性能之謎
marcustung
0
140
君たちはどうプログラミングするか
tanakahisateru
7
910
エンジニア秘書が通訳する異文化コミュニケーションのあれこれ / engineer-communication
assu_ming
0
130
KDDI共同講演：@niftyメール基盤移行プロジェクト - NIFTY Tech Day 2023
niftycorp
0
120

Featured

See All Featured
Optimizing for Happiness
mojombo
368
68k
A Philosophy of Restraint
colly
194
15k
Easily Structure & Communicate Ideas using Wireframe
afnizarnur
185
15k
Building a Modern Day 
E-commerce SEO Strategy
aleyda
13
5.9k
Art, The Web, and Tiny UX
lynnandtonic
286
19k
Fireside Chat
paigeccino
18
2.3k
Stop Working from a Prison Cell
hatefulcrawdad
264
18k
"I'm Feeling Lucky" - Building Great Search Experiences for Today's Users (#IAC19)
danielanewman
219
21k
How GitHub (no longer) Works
holman
299
140k
Creating an realtime collaboration tool: Agile Flush - .NET Oxford
marcduiker
10
1.3k
We Have a Design System, Now What?
morganepeng
41
6.5k
Web development in the modern age
philhawksworth
201
9.9k

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