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

Faster Queries = More Animal Crossing

Sponsored · SiteGround - Reliable hosting with speed, security, and support you can count on. →
Avatar for Jonan Scheffler Jonan Scheffler
March 31, 2020
Programming
240
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
28
inventing_friends.pdf
Avatar for Jonan Scheffler thejonanshow
0
34
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
53
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
実用！Hono RPC2026
Avatar for yodaka yodaka
2
240
JOAI2026 1st solution - heron0519 -
Avatar for heron0519 heron0519
0
140
🦞OpenClaw works with AWS
Avatar for matsukada licux
1
180
Coding at the Speed of Thought: The New Era of Symfony Docker
Avatar for Kévin Dunglas dunglas
0
5k
2026_04_15_量子計算をパズルとして解く
Avatar for HideakiTakechi hideakitakechi
0
110
第3木曜LT会 #28
Avatar for Tsubasa SEKIGUCHI tinykitten
PRO
0
110
Kingdom of the Machine
Avatar for yui-knk yui_knk
2
690
Claude CodeでETLジョブ実行テストを自動化してみた
Avatar for yoshiki kasama yoshikikasama
0
130
How We Benchmarked Quarkus: Patterns and anti-patterns
Avatar for Holly Cummins hollycummins
1
150
TiDBのアーキテクチャから学ぶ分散システム入門 〜MySQL互換のNewSQLは何を解決するのか〜 / tidb-architecture-study
Avatar for DPon dznbk
1
180
Surviving Black Friday: 329 billion requests with Falcon!
Avatar for Samuel Williams ioquatix
0
650
事業会社でのセキュリティ長期インターンについて
Avatar for inlet-back masachikaura
0
260

Featured

See All Featured
AI: The stuff that nobody shows you
Avatar for John Nunemaker jnunemaker
PRO
6
580
A brief & incomplete history of 
UX Design for the World Wide Web: 1989–2019
Avatar for Jason CranfordTeague jct
1
360
The Pragmatic Product Professional
Avatar for Laura Van Doore lauravandoore
37
7.2k
Principles of Awesome APIs and How to Build Them.
Avatar for Keavy McMinn keavy
128
17k
SEO for Brand Visibility & Recognition
Avatar for Aleyda Solis aleyda
0
4.5k
Scaling GitHub
Avatar for Zach Holman holman
464
140k
The Success of Rails: Ensuring Growth for the Next 100 Years
Avatar for Eileen M. Uchitelle eileencodes
47
8.1k
Fantastic passwords and where to find them - at NoRuKo
Avatar for Phil Nash philnash
52
3.7k
Optimising Largest Contentful Paint
Avatar for Harry Roberts csswizardry
37
3.6k
svc-hook: hooking system calls on ARM64 by binary rewriting
Avatar for Akira Moroo retrage
2
220
Rails Girls Zürich Keynote
Avatar for Gregor Martynus gr2m
96
14k
brightonSEO & MeasureFest 2025 - Christian Goodrich - Winning strategies for Black Friday CRO & PPC
Avatar for Christian Goodrich cargoodrich
3
680

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