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
0
230

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
Tweet

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
28
inventing_friends.pdf
Avatar for Jonan Scheffler thejonanshow
0
32
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
51
Robolove
Avatar for Jonan Scheffler thejonanshow
0
86
Hacking Cognition
Avatar for Jonan Scheffler thejonanshow
2
130

Other Decks in Programming

See All in Programming
QAフローを最適化し、品質水準を満たしながらリリースまでの期間を最短化する #RSGT2026
Avatar for shibayu36 shibayu36
2
4.4k
AI Schema Enrichment for your Oracle AI Database
Avatar for thatjeffsmith thatjeffsmith
0
330
Package Management Learnings from Homebrew
Avatar for Mike McQuaid mikemcquaid
0
230
生成AIを使ったコードレビューで定性的に品質カバー
Avatar for Chiaki Okamoto chiilog
1
280
izumin5210のプロポーザルのネタ探し #tskaigi_msup
Avatar for izumin5210 izumin5210
1
140
CSC307 Lecture 07
Avatar for Javier Gonzalez-Sanchez javiergs
PRO
1
560
CSC307 Lecture 01
Avatar for Javier Gonzalez-Sanchez javiergs
PRO
0
690
生成AIを活用したソフトウェア開発ライフサイクル変革の現在値
Avatar for Hiroyuki Mori hiroyukimori
PRO
0
100
Data-Centric Kaggle
Avatar for ねぼすけAI isax1015
2
780
プロダクトオーナーから見たSOC2 _SOC2ゆるミートアップ#2
Avatar for Kenta Suzuki kekekenta
0
220
Unicodeどうしてる？ PHPから見たUnicode対応と他言語での対応についてのお伺い
Avatar for てきめん tekimen youkidearitai
PRO
1
2.6k
カスタマーサクセス業務を変革したヘルススコアの実現と学び
Avatar for Tomoyuki Hamaguchi _hummer0724
0
730

Featured

See All Featured
Leadership Guide Workshop - DevTernity 2021
Avatar for David Neal reverentgeek
1
200
Refactoring Trust on Your Teams (GOTO; Chicago 2020)
Avatar for Rebecca Miller-Webster rmw
35
3.4k
Dealing with People You Can't Stand - Big Design 2015
Avatar for Cassini Nazir cassininazir
367
27k
Code Reviewing Like a Champion
Avatar for maltzj maltzj
527
40k
Six Lessons from altMBA
Avatar for Skipper Chong Warson skipperchong
29
4.2k
A Soul's Torment
Avatar for Nat Ma seathinner
5
2.3k
We Analyzed 250 Million AI Search Results: Here's What I Found
Avatar for Josh Blyskal joshbly
1
750
A designer walks into a library…
Avatar for Paul Jervis Heath pauljervisheath
210
24k
Principles of Awesome APIs and How to Build Them.
Avatar for Keavy McMinn keavy
128
17k
The Director’s Chair: Orchestrating AI for Truly Effective Learning
Avatar for Mike Taylor tmiket
1
98
Design in an AI World
Avatar for tapps tapps
0
150
The Impact of AI in SEO - AI Overviews June 2024 Edition
Avatar for Aleyda Solis aleyda
5
740

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