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

Faster Queries = More Animal Crossing

Avatar for Jonan Scheffler Jonan Scheffler
March 31, 2020
Programming
250
0

Faster Queries = More Animal Crossing

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

Avatar for Jonan Scheffler

Jonan Scheffler

March 31, 2020

More Decks by Jonan Scheffler

See All by Jonan Scheffler
Sleeping in Airports: The Magical, Terrible Life of a Developer Advocate
Avatar for Jonan Scheffler thejonanshow
0
29
inventing_friends.pdf
Avatar for Jonan Scheffler thejonanshow
0
35
Inventing Friends: Actioncable + AVS = <3
Avatar for Jonan Scheffler thejonanshow
0
100
Building HAL: Running Ruby with your Voice
Avatar for Jonan Scheffler thejonanshow
1
110
Deploying MEAN on Heroku
Avatar for Jonan Scheffler thejonanshow
2
56
Robolove
Avatar for Jonan Scheffler thejonanshow
0
87
Hacking Cognition
Avatar for Jonan Scheffler thejonanshow
2
130

Other Decks in Programming

See All in Programming
AgentCore Optimizationを始めよう！
Avatar for matsukada licux
3
240
AI時代になぜ書くのか
Avatar for Mutz mutsumix
0
410
なぜあなたのコードには「コシ」がないのか？〜AI時代に問う、最後まで美味しい設計と戦略〜 #phpconkagawa / phpconkagawa2026
Avatar for shogogg shogogg
0
210
過去のレビュー知見をSkillsで資産化した話
Avatar for PKSHA Technology（パークシャテクノロジー） pkshadeck
PRO
1
2k
サーバーレスで作る、動画データ管理基盤
Avatar for Keigo Ibaraki oyasumipants
0
200
Spec Driven Development | AI Summit Vilnius
Avatar for Daniel Sogl danielsogl
PRO
1
160
20260514_its_the_context_window_stupid.pdf
Avatar for heita heita
0
1k
実践ハーネスエンジニアリング：ステアリングループを実例から読み解く / Practical Harness Engineering: Understanding Steering Loops Through Real-World Examples
Avatar for nrs nrslib
5
5.5k
密結合なバックエンドから TypeScript のコードを生成する
Avatar for kemuridama kemuridama
0
150
Skillは並べた。動かなかった。契約で繋いだ。— 65個のSkillから、自走する開発サイクルへ
Avatar for じゅん junholee
0
600
GitHubCopilotCLIをはじめよう.pdf
Avatar for tkym htkym
0
330
Cloudflare で始める Data Platform
Avatar for Takumi Abe ta93abe
0
170

Featured

See All Featured
How to make the Groovebox
Avatar for あそなす asonas
2
2.2k
Abbi's Birthday
Avatar for Violet Bock coloredviolet
2
7.6k
For a Future-Friendly Web
Avatar for Brad Frost brad_frost
183
10k
What Being in a Rock Band Can Teach Us About Real World SEO
Avatar for Ade Holder 427marketing
0
230
職位にかかわらず全員がリーダーシップを発揮するチーム作り / Building a team where everyone can demonstrate leadership regardless of position
Avatar for MADOX madoxten
62
54k
sira's awesome portfolio website redesign presentation
Avatar for ElsiraPls elsirapls
0
240
Making the Leap to Tech Lead
Avatar for Ryan Cromwell cromwellryan
135
9.8k
YesSQL, Process and Tooling at Scale
Avatar for Rocio Delgado rocio
174
15k
Money Talks: Using Revenue to Get Sh*t Done
Avatar for Nikki Halliwell nikkihalliwell
0
220
Facilitating Awesome Meetings
Avatar for Lara Hogan lara
57
6.8k
Max Prin - Stacking Signals: How International SEO Comes Together (And Falls Apart)
Avatar for Tech SEO Connect techseoconnect
PRO
0
160
Joys of Absence: A Defence of Solitary Play
Avatar for Sebastian Deterding codingconduct
1
360

Transcript

  1. FASTER QUERIES = MORE ANIMAL CROSSING

  2. @thejonanshow

  3. @thejonanshow

  4. @thejonanshow

  5. @thejonanshow

  6. @thejonanshow

  7. @thejonanshow

  8. @thejonanshow

  9. @thejonanshow

  10. @thejonanshow

  11. @thejonanshow

  12. @thejonanshow

  13. @thejonanshow

  14. @thejonanshow

  15. @thejonanshow

  16. @thejonanshow

  17. @thejonanshow

  18. @thejonanshow

  19. @thejonanshow

  20. @thejonanshow

  21. @thejonanshow

  22. @thejonanshow

  23. @thejonanshow

  24. @thejonanshow

  25. @thejonanshow

  26. @thejonanshow

  27. @thejonanshow

  28. @thejonanshow

  29. @thejonanshow

  30. @thejonanshow

  31. @thejonanshow

  32. @thejonanshow

  33. @thejonanshow

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

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

    LIKE and ILIKE dodge indexes, use pg_trgm

  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

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