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

Faster Queries = More Animal Crossing

7353db17cf19f920fbd24479c8157781?s=47 Jonan Scheffler
March 31, 2020
Programming
0
83

Faster Queries = More Animal Crossing

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

7353db17cf19f920fbd24479c8157781?s=128

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
7353db17cf19f920fbd24479c8157781?s=48 thejonanshow
0
6
inventing_friends.pdf
7353db17cf19f920fbd24479c8157781?s=48 thejonanshow
0
10
Inventing Friends: Actioncable + AVS = <3
7353db17cf19f920fbd24479c8157781?s=48 thejonanshow
0
73
Building HAL: Running Ruby with your Voice
7353db17cf19f920fbd24479c8157781?s=48 thejonanshow
1
52
Deploying MEAN on Heroku
7353db17cf19f920fbd24479c8157781?s=48 thejonanshow
2
36
Robolove
7353db17cf19f920fbd24479c8157781?s=48 thejonanshow
0
32
Hacking Cognition
7353db17cf19f920fbd24479c8157781?s=48 thejonanshow
2
100

Other Decks in Programming

See All in Programming
GitHubのユーザー名を変更した後のあれこれ
E4b008af82e3a9b3cbae5b757b22c54e?s=48 tahia910
0
120
Keeping your team in top shape with the Gradle Enterprise API
5f69045a2ca496221cfc624405917cdf?s=48 runningcode
3
120
Branching out to Jetpack Compose
86f746f6c0c522ab2261bd55791d8a4a?s=48 chrisbanes
4
1.1k
Gitlab CIでMRを自動生成する
1a2f29252240936c0ac4db4edab36d41?s=48 forcia_dev_pr
0
110
模組化的Swift架構(二) DDD速成
A3d3b179955bdea9fc05b3251f1b1f10?s=48 haifengkao
0
310
Embracing commonMain for Android Development - Droidcon SF 2022
5701f31a8433a22ae736282de8d08cd6?s=48 handstandsam
4
220
Scrum Fest Osaka 2022/5年で200人になったスタートアップの アジャイル開発の歴史とリアル
F0a8d07597a19192791bf663504d2a17?s=48 atamaplus
1
760
Reactアプリケーションのテスト戦略
D661ba250e003e83b03c25852b27d3f8?s=48 0906koki
10
4.5k
実践エクストリームプログラミング / Extreme Programming in Practice
00cbada6669966805d91061d5a234d3b?s=48 enk
0
190
Terraform Plan/Apply結果の自動通知
92a1e043fcefaed6e1b89182b1cd34a5?s=48 ymmy02
0
270
Cross Deviceチームにおけるスマートテレビアプリ開発ってどんな感じ？
95f926465b1c71fbb49850c5b6223c4d?s=48 cokaholic
0
120
Meet Swift Regex
0b26590a0a8b0f1da140ed5de9b68379?s=48 usamik26
0
150

Featured

See All Featured
How to Ace a Technical Interview
2f5463832ccb768ccb4a1ca3607c27ef?s=48 jacobian
265
21k
Intergalactic Javascript Robots from Outer Space
6804f1775cb4babfcc3851298566fbce?s=48 tanoku
261
25k
A Philosophy of Restraint
C9b18d9dff88a9dd2393364c2b3b21bd?s=48 colly
192
15k
Visualizing Your Data: Incorporating Mongo into Loggly Infrastructure
D8fc2580cfaca035f666d9e4ee79a7f7?s=48 mongodb
29
4.3k
Stop Working from a Prison Cell
C1daf20e5c49ff910745198ef9869ac2?s=48 hatefulcrawdad
261
17k
Atom: Resistance is Futile
7fa6101cd43067653cf4ac6c7ca54305?s=48 akmur
255
20k
How to name files
0a4f62e90c976eeb44d33add75cca5af?s=48 jennybc
40
60k
Gamification - CAS2011
4394ceb8b277f35ee3da7030384efb5d?s=48 davidbonilla
75
3.9k
Principles of Awesome APIs and How to Build Them.
B47b288784fda77a94aeb234ca743c24?s=48 keavy
113
15k
Adopting Sorbet at Scale
2bb923c57a1fdc3a2eb484bb8d565fd2?s=48 ufuk
63
7.6k
Why Our Code Smells
20bfe76b3d6105641f879fe45cfc9272?s=48 bkeepers
PRO
324
55k
Building an army of robots
5f2da528927a2ec9ba4fec2069cbc958?s=48 kneath
299
40k

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