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
150
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
21
inventing_friends.pdf
thejonanshow
0
22
Inventing Friends: Actioncable + AVS = <3
thejonanshow
0
91
Building HAL: Running Ruby with your Voice
thejonanshow
1
82
Deploying MEAN on Heroku
thejonanshow
2
42
Robolove
thejonanshow
0
77
Hacking Cognition
thejonanshow
2
120
Other Decks in Programming
See All in Programming
スクラムマスターって孤独じゃないですか?
yoshitaroyoyo
1
140
APIのない大学ログインWebサービスをWKWebViewとJavaScriptでアプリ化した話
akidon0000
1
330
君たちはどうコードをレビューする (される) か / 大吉祥寺.pm
utgwkk
15
8.5k
DynamoDB コスト最適化っぽいことの基本 with Terraform
kuro_kurorrr
2
250
The rollercoaster of releasing an Android, iOS, and macOS app with Kotlin Multiplatform | droidcon Berlin
prof18
0
110
はしめてのプログラミングとロボット制御
watawatavoltage
0
290
日付と正規化
megmogmog1965
0
140
Architectures with Lightweight Stores: New Rules and Options
manfredsteyer
PRO
0
100
Harnessing Large Language Models for Training-free Video Anomaly Detection
tereka114
1
1.3k
CSC307 Lecture 14
javiergs
PRO
0
220
AWSでゲームサーバーを運用! Amazon GameLiftのお話
iriikeita
0
200
SDCon2024: Enabling DevOps and Team Topologies thru architecture: architecting for fast flow
cer
PRO
0
780
Featured
See All Featured
Web development in the modern age
philhawksworth
203
10k
Thoughts on Productivity
jonyablonski
64
4.1k
For a Future-Friendly Web
brad_frost
173
9.2k
10 Git Anti Patterns You Should be Aware of
lemiorhan
652
58k
Fireside Chat
paigeccino
25
2.8k
Designing the Hi-DPI Web
ddemaree
276
34k
Faster Mobile Websites
deanohume
303
30k
Building a Modern Day E-commerce SEO Strategy
aleyda
25
6.7k
Speed Design
sergeychernyshev
9
270
Put a Button on it: Removing Barriers to Going Fast.
kastner
58
3.3k
Visualization
eitanlees
139
14k
The Brand Is Dead. Long Live the Brand.
mthomps
52
36k
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