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
Sponsored
·
Ship Features Fearlessly
Turn features on and off without deploys. Used by thousands of Ruby developers.
→
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
28
inventing_friends.pdf
thejonanshow
0
32
Inventing Friends: Actioncable + AVS = <3
thejonanshow
0
100
Building HAL: Running Ruby with your Voice
thejonanshow
1
110
Deploying MEAN on Heroku
thejonanshow
2
51
Robolove
thejonanshow
0
86
Hacking Cognition
thejonanshow
2
130
Other Decks in Programming
See All in Programming
CSC307 Lecture 09
javiergs
PRO
1
840
Oxlintはいいぞ
yug1224
5
1.4k
組織で育むオブザーバビリティ
ryota_hnk
0
180
開発者から情シスまで - 多様なユーザー層に届けるAPI提供戦略 / Postman API Night Okinawa 2026 Winter
tasshi
0
210
登壇資料を作る時に意識していること #登壇資料_findy
konifar
4
1.6k
AIエージェントのキホンから学ぶ「エージェンティックコーディング」実践入門
masahiro_nishimi
6
610
カスタマーサクセス業務を変革したヘルススコアの実現と学び
_hummer0724
0
730
HTTPプロトコル正しく理解していますか? 〜かわいい猫と共に学ぼう。ฅ^•ω•^ฅ ニャ〜
hekuchan
2
690
humanlayerのブログから学ぶ、良いCLAUDE.mdの書き方
tsukamoto1783
0
200
Fluid Templating in TYPO3 14
s2b
0
130
Oxlint JS plugins
kazupon
1
1k
それ、本当に安全? ファイルアップロードで見落としがちなセキュリティリスクと対策
penpeen
7
4k
Featured
See All Featured
Bridging the Design Gap: How Collaborative Modelling removes blockers to flow between stakeholders and teams @FastFlow conf
baasie
0
450
Connecting the Dots Between Site Speed, User Experience & Your Business [WebExpo 2025]
tammyeverts
11
830
Embracing the Ebb and Flow
colly
88
5k
世界の人気アプリ100個を分析して見えたペイウォール設計の心得
akihiro_kokubo
PRO
66
37k
Principles of Awesome APIs and How to Build Them.
keavy
128
17k
AI Search: Implications for SEO and How to Move Forward - #ShenzhenSEOConference
aleyda
1
1.1k
Ethics towards AI in product and experience design
skipperchong
2
200
How STYLIGHT went responsive
nonsquared
100
6k
Leveraging LLMs for student feedback in introductory data science courses - posit::conf(2025)
minecr
0
160
Distributed Sagas: A Protocol for Coordinating Microservices
caitiem20
333
22k
Tips & Tricks on How to Get Your First Job In Tech
honzajavorek
0
440
Leading Effective Engineering Teams in the AI Era
addyosmani
9
1.6k
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