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
230
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
あなたとJIT, 今すぐアセンブ ル
sisshiki1969
0
180
「次に何を学べばいいか分からない」あなたへ──若手エンジニアのための学習地図
panda_program
3
710
CEDEC 2025 『ゲームにおけるリアルタイム通信への QUIC導入事例の紹介』
segadevtech
3
760
Claude Code と OpenAI o3 で メタデータ情報を作る
laket
0
110
decksh - a little language for decks
ajstarks
4
21k
Bedrock AgentCore ObservabilityによるAIエージェントの運用
licux
8
560
Android 15以上でPDFのテキスト検索を爆速開発!
tonionagauzzi
0
190
Gemini CLIの"強み"を知る! Gemini CLIとClaude Codeを比較してみた!
kotahisafuru
3
920
No Install CMS戦略 〜 5年先を見据えたフロントエンド開発を考える / no_install_cms
rdlabo
0
440
Constant integer division faster than compiler-generated code
herumi
2
230
実践 Dev Containers × Claude Code
touyu
1
140
Go製CLIツールをnpmで配布するには
syumai
2
1.1k
Featured
See All Featured
Building a Scalable Design System with Sketch
lauravandoore
462
33k
How GitHub (no longer) Works
holman
314
140k
Adopting Sorbet at Scale
ufuk
77
9.5k
Site-Speed That Sticks
csswizardry
10
750
Building an army of robots
kneath
306
45k
A better future with KSS
kneath
238
17k
RailsConf & Balkan Ruby 2019: The Past, Present, and Future of Rails at GitHub
eileencodes
139
34k
Music & Morning Musume
bryan
46
6.7k
実際に使うSQLの書き方 徹底解説 / pgcon21j-tutorial
soudai
PRO
183
54k
[RailsConf 2023] Rails as a piece of cake
palkan
56
5.7k
A Modern Web Designer's Workflow
chriscoyier
695
190k
Into the Great Unknown - MozCon
thekraken
40
2k
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