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

Faster Queries = More Animal Crossing

Sponsored · Your Podcast. Everywhere. Effortlessly. Share. Educate. Inspire. Entertain. You do you. We'll handle the rest. →
Avatar for Jonan Scheffler Jonan Scheffler
March 31, 2020
Programming
260
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
30
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
120
Deploying MEAN on Heroku
Avatar for Jonan Scheffler thejonanshow
2
58
Robolove
Avatar for Jonan Scheffler thejonanshow
0
89
Hacking Cognition
Avatar for Jonan Scheffler thejonanshow
2
140

Other Decks in Programming

See All in Programming
Java × distroless で 軽量なコンテナイメージを / Java on Distroless
Avatar for Daisuke Garaike contour_gara
0
490
IBM Bobを活用したレガシーアプリの最新化
Avatar for Akira Onishi (IBM) oniak3ibm
PRO
1
170
AIとASP.NET Coreで雑Webアプリを作った話
Avatar for Mayuki Sawatari mayuki
0
290
LLM本来の能力を解き放つサンドボックス技術とAI民主化への適用
Avatar for Yuku Kotani yukukotani
3
2.7k
jQueryをバージョンアップする前に使いたいjQuery Migrate
Avatar for Atsushi Matsuo matsuo_atsushi
0
180
Lemonade + Foundry Toolkit でお手軽アプリ開発
Avatar for 瀬尾佳隆 seosoft
1
300
運用エージェントは "作る" から "育てる" へ - 記憶と自己進化の3層設計パターン / self-evolving-agents-three-layer-agent-design
Avatar for geeawa gawa
12
3.5k
関係性から理解する"同一性"の型用語たち
Avatar for pvcresin pvcresin
2
630
AI時代のUIはどこへ行く？その2！
Avatar for Yusuke Wada yusukebe
19
6.6k
RTSPクライアントを自作してみた話
Avatar for simotin13 simotin13
0
450
AI 時代のソフトウェア設計の学び方
Avatar for 増田 亨 masuda220
PRO
29
12k
TypeScriptだけでAIエージェントを作る フロント・エージェント・インフラのフルスタック実践
Avatar for Har1101 har1101
6
1.3k

Featured

See All Featured
Navigating Team Friction
Avatar for Lara Hogan lara
192
16k
Measuring Dark Social's Impact On Conversion and Attribution
Avatar for Stephen Akadiri stephenakadiri
2
210
How Fast Is Fast Enough? [PerfNow 2025]
Avatar for Tammy Everts tammyeverts
3
600
世界の人気アプリ100個を分析して見えたペイウォール設計の心得
Avatar for Akihiro Kokubo akihiro_kokubo
PRO
71
40k
Leveraging Curiosity to Care for An Aging Population
Avatar for Cassini Nazir cassininazir
1
260
Ten Tips & Tricks for a 🌱 transition
Avatar for Manu Carrasco Molina stuffmc
0
130
Rails Girls Zürich Keynote
Avatar for Gregor Martynus gr2m
96
14k
The Limits of Empathy - UXLibs8
Avatar for Cassini Nazir cassininazir
1
350
How to Create Impact in a Changing Tech Landscape [PerfNow 2023]
Avatar for Tammy Everts tammyeverts
55
3.4k
Designing for Performance
Avatar for Lara Hogan lara
611
70k
Believing is Seeing
Avatar for Spiro Bolos oripsolob
1
140
How to Grow Your eCommerce with AI & Automation
Avatar for Katarina Dahlin katarinadahlin
PRO
1
200

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