Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
Faster Queries = More Animal Crossing
Search
Jonan Scheffler
March 31, 2020
Programming
0
220
Faster Queries = More Animal Crossing
A quick walkthrough of common query inefficiencies using PostgreSQL and TimescaleDB.
Jonan Scheffler
March 31, 2020
Tweet
Share
More Decks by Jonan Scheffler
See All by Jonan Scheffler
Sleeping in Airports: The Magical, Terrible Life of a Developer Advocate
thejonanshow
0
26
inventing_friends.pdf
thejonanshow
0
24
Inventing Friends: Actioncable + AVS = <3
thejonanshow
0
96
Building HAL: Running Ruby with your Voice
thejonanshow
1
100
Deploying MEAN on Heroku
thejonanshow
2
49
Robolove
thejonanshow
0
81
Hacking Cognition
thejonanshow
2
120
Other Decks in Programming
See All in Programming
GitHub Copilot and GitHub Codespaces Hands-on
ymd65536
1
110
FormFlow - Build Stunning Multistep Forms
yceruto
1
190
PHP 8.4の新機能「プロパティフック」から学ぶオブジェクト指向設計とリスコフの置換原則
kentaroutakeda
2
470
ruby.wasmで多人数リアルタイム通信ゲームを作ろう
lnit
2
250
Julia という言語について (FP in Julia « SIDE: F ») for 関数型まつり2025
antimon2
3
980
AIコーディング道場勉強会#2 君(エンジニア)たちはどう生きるか
misakiotb
1
240
Railsアプリケーションと パフォーマンスチューニング ー 秒間5万リクエストの モバイルオーダーシステムを支える事例 ー Rubyセミナー 大阪
falcon8823
4
920
deno-redisの紹介とJSRパッケージの運用について (toranoana.deno #21)
uki00a
0
140
来たるべき 8.0 に備えて React 19 新機能と React Router 固有機能の取捨選択とすり合わせを考える
oukayuka
2
840
iOSアプリ開発で 関数型プログラミングを実現する The Composable Architectureの紹介
yimajo
2
210
なぜ適用するか、移行して理解するClean Architecture 〜構造を超えて設計を継承する〜 / Why Apply, Migrate and Understand Clean Architecture - Inherit Design Beyond Structure
seike460
PRO
1
660
Deep Dive into ~/.claude/projects
hiragram
7
1.3k
Featured
See All Featured
Fight the Zombie Pattern Library - RWD Summit 2016
marcelosomers
233
17k
A designer walks into a library…
pauljervisheath
206
24k
We Have a Design System, Now What?
morganepeng
53
7.7k
Optimising Largest Contentful Paint
csswizardry
37
3.3k
Stop Working from a Prison Cell
hatefulcrawdad
270
20k
YesSQL, Process and Tooling at Scale
rocio
173
14k
Intergalactic Javascript Robots from Outer Space
tanoku
271
27k
Optimizing for Happiness
mojombo
379
70k
Documentation Writing (for coders)
carmenintech
71
4.9k
Git: the NoSQL Database
bkeepers
PRO
430
65k
Being A Developer After 40
akosma
90
590k
GitHub's CSS Performance
jonrohan
1031
460k
Transcript
FASTER QUERIES = MORE ANIMAL CROSSING
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow
@thejonanshow - Common Table Expressions slow down small queries
@thejonanshow - Common Table Expressions slow down small queries -
LIKE and ILIKE dodge indexes, use pg_trgm
@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
@thejonanshow Thank You! ❤ github.com/timescale/wikistream-docker