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
28
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
50
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
[AtCoder Conference 2025] LLMを使った業務AHCの上⼿な解き⽅
Avatar for terry-u16 terryu16
6
850
これならできる！個人開発のすゝめ
Avatar for Tsubasa SEKIGUCHI tinykitten
PRO
0
130
クラウドに依存しないS3を使った開発術
Avatar for しめさば simesaba80
0
180
LLM Çağında Backend Olmak: 10 Milyon Prompt'u Milisaniyede Sorgulamak
Avatar for Selçuk Usta selcukusta
0
140
Rubyで鍛える仕組み化プロヂュース力
Avatar for muryoimpl muryoimpl
0
210
AtCoder Conference 2025「LLM時代のAHC」
Avatar for Yuki Imajuku imjk
2
600
愛される翻訳の秘訣
Avatar for Kishikawa Katsumi kishikawakatsumi
3
350
認証・認可の基本を学ぼう後編
Avatar for kaza kouyuume
0
250
Spinner 軸ズレ現象を調べたらレンダリング深淵に飲まれた #レバテックMeetup
Avatar for 弁護士ドットコム bengo4com
0
190
Denoのセキュリティに関する仕組みの紹介 (toranoana.deno #23)
Avatar for uki00a uki00a
0
180
Developing static sites with Ruby
Avatar for Masafumi Okura okuramasafumi
0
330
gunshi
Avatar for kazupon kazupon
1
120

Featured

See All Featured
The Director’s Chair: Orchestrating AI for Truly Effective Learning
Avatar for Mike Taylor tmiket
0
67
Side Projects
Avatar for Sacha Greif sachag
455
43k
Fireside Chat
Avatar for paigeccino paigeccino
41
3.8k
The Cost Of JavaScript in 2023
Avatar for Addy Osmani addyosmani
55
9.4k
State of Search Keynote: SEO is Dead Long Live SEO
Avatar for Ryan Jones ryanjones
0
73
Crafting Experiences
Avatar for Bethany Jepchumba bethany
0
22
The Psychology of Web Performance [Beyond Tellerrand 2023]
Avatar for Tammy Everts tammyeverts
49
3.2k
Being A Developer After 40
Avatar for Adrian Kosmaczewski akosma
91
590k
The browser strikes back
Avatar for Jono Alderson jonoalderson
0
230
Accessibility Awareness
Avatar for Sarah Abderemane sabderemane
0
24
Designing for humans not robots
Avatar for Tammie Lister tammielis
254
26k
The World Runs on Bad Software
Avatar for Brandon Keepers bkeepers
PRO
72
12k

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