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
130
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
16
inventing_friends.pdf
thejonanshow
0
21
Inventing Friends: Actioncable + AVS = <3
thejonanshow
0
89
Building HAL: Running Ruby with your Voice
thejonanshow
1
76
Deploying MEAN on Heroku
thejonanshow
2
41
Robolove
thejonanshow
0
67
Hacking Cognition
thejonanshow
2
110
Other Decks in Programming
See All in Programming
Random\Randomizer クラスで日常のあれこれを解決しよう! / Random\Randomizer class solves familiar trouble
cocoeyes02
0
200
スキーマ駆動開発による品質とスピードの両立 - 私達は何故、スキーマを書くのか
kentaroutakeda
0
170
入門 AWS Amplify Gen2 / Introduction to AWS Amplify Gen2
genkiogasawara
1
330
Site Reliability Engineering for GMO
pyama86
7
1k
Anthropic Cookbook のおすすめレシピ
schroneko
7
870
Snowflakeで眠ったデータを起こそう!
estie
0
110
ONE WEDGE_company_guide
1wedge_one
0
460
Ruby Function Composition
bkuhlmann
1
330
ADRを一年運用してみた/adr_after_a_year
hanhan1978
7
2.3k
[技育CAMPアカデミア]アイディアを形に!【超入門】スマホアプリ開発〜リリースまでの流れをご紹介
teamlab
PRO
0
360
Blue/Greenデプロイの導入による 運用フローの改善
kudoas
1
370
Rubyでたのしむクリエイティブコーディング/Enjoy Creative coding with Ruby
chobishiba
1
180
Featured
See All Featured
Done Done
chrislema
178
15k
Adopting Sorbet at Scale
ufuk
68
8.6k
Embracing the Ebb and Flow
colly
80
4.1k
Principles of Awesome APIs and How to Build Them.
keavy
121
16k
ピンチをチャンスに:未来をつくるプロダクトロードマップ #pmconf2020
aki_iinuma
78
42k
How STYLIGHT went responsive
nonsquared
92
4.8k
KATA
mclloyd
15
12k
Fontdeck: Realign not Redesign
paulrobertlloyd
76
4.9k
[RailsConf 2023 Opening Keynote] The Magic of Rails
eileencodes
9
8.3k
The MySQL Ecosystem @ GitHub 2015
samlambert
243
12k
Designing for Performance
lara
601
67k
The Invisible Customer
myddelton
114
12k
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