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
170
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
What is TDD?
urakawa_jinsei
1
210
Progressive Web Apps for Rails developers
siaw23
2
530
VS Code extension: ドラッグ&ドロップでファイルを並び替える
ttrace
0
160
sqlcを利用してsqlに型付けを
kamiyam
0
230
선언형 UI를 학습할 때 알아둬야하는 키워드들
l2hyunwoo
0
120
Unlocking Python's Core Magic
leew
0
120
いまあるチームにフィットさせる Serverless そして Platform Engineeringへの挑戦 / Serverless Fits the Team You Have and Platform Engineering
seike460
PRO
2
1.4k
NEWTにおけるiOS18対応の進め方
ryu1sazae
0
190
The Efficiency Paradox and How to Save Yourself and the World
hollycummins
0
150
Re:PandasAI:生成AIがデータ分析業務にもたらすパラダイムシフト【増補改訂版】
negi111111
1
860
DjangoNinjaで高速なAPI開発を実現する
masaya00
0
480
M5Stack に色々な M5ユニットをつないで扱う為の新たなアプローチ
gob
0
200
Featured
See All Featured
Imperfection Machines: The Place of Print at Facebook
scottboms
264
13k
A Philosophy of Restraint
colly
202
16k
JavaScript: Past, Present, and Future - NDC Porto 2020
reverentgeek
45
4.9k
The Language of Interfaces
destraynor
154
24k
個人開発の失敗を避けるイケてる考え方 / tips for indie hackers
panda_program
92
16k
Optimising Largest Contentful Paint
csswizardry
31
2.8k
Large-scale JavaScript Application Architecture
addyosmani
509
110k
Evolution of real-time – Irina Nazarova, EuRuKo, 2024
irinanazarova
2
220
Performance Is Good for Brains [We Love Speed 2024]
tammyeverts
1
250
Happy Clients
brianwarren
97
6.7k
GraphQLとの向き合い方2022年版
quramy
43
13k
Atom: Resistance is Futile
akmur
261
25k
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